QADBXREF file attributes

850 pts.
Tags:
AS 400
Database
QADBXREF
This is a challenging question: System Cross Reference file QADBXREF field name DBXATR = 'CL'. What is "CL" file attribute type for a file (not a program)? I know the standards PF, LF, AR etc but I have one file on the system that I cannot find on the system and it is the only one that is file attribute type "CL". Or, I have a file listed in the system cross reference file, that I cannot find on the system; therefore, I cannot remove it from the system.  How do I find files that are listed file attribute "CL".

Software/Hardware used:
AS/400

Answer Wiki

Thanks. We'll let you know when a new response is added.

CL is most likely Control Language program. You may see some CLLE as well, those are just a higher level CL program.

This is incorrect.  We are talking about a file object; not a program object.  

Discuss This Question: 14  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Modiyooch
    Todd, I'm not talking about programs. I'm dealing with every file on the system. VW, TB, PF, LF, IX, AL, etc. What is file attribute type "CL"

    Thank for trying. I cannot find it in any documentation.
    850 pointsBadges:
    report
  • ToddN2000
    Where is this CL showing up, in the DBXATR column?... If using the QASBXREF it looks like it's not valid for a file attribute? The only ones I see are 

    PF-physical,LF-logical,TB-table,VW-view,IX-index

    What release are you running?
    115,410 pointsBadges:
    report
  • ToddN2000
    Poked around a bit and found this link that mentions it.
    Looks like it may be an older file format no longer supported

    OUTFILE

    115,410 pointsBadges:
    report
  • Modiyooch
    I think that article refers to using cl programs to output file information to database files, and that it is no longer necessary since cross reference files exists. I've been googling for a week and unfortunately it keeps referring to CL programs. Btw, we ran a check on the integrity of the system file and no errors show, so IBM will not permit reclaim storage on the cross reference file. Information is not to be found. It incomplete documentation regarding the system file.
    850 pointsBadges:
    report
  • Modiyooch
    Btw, the file is not old. The naming convention is based on employee code, and the employee has only worked 2 years.
    850 pointsBadges:
    report
  • ToddN2000
    I guess as a last resort if you have IBM maintenance as them and mention you cannot find anything on the CL in any documentation or literature online. I'll keep poking a bit and call a few contacts I worked with in the past. Very strange there is nothing for the attribute type CL.
    115,410 pointsBadges:
    report
  • Modiyooch
    I've asked ADMIN to ask IBM, but it just isn't happening. I was hoping someone could shed some light. It's the only CL type file on the system and it was used in ODBC application. The other ddmf files are type AR and I can access them for deletion.
    0 pointsBadges:
    report
  • Modiyooch
    Yes dbxatr. That documentation is incomplete. I also have types AR. AL. We are on 7.2
    0 pointsBadges:
    report
  • ToddN2000
    I love the way IBM is right up to date on their documentation....lol. If I figure out the CL type, I'll post back.
    0 pointsBadges:
    report
  • Modiyooch
    A hardware upgrade removed the file from the system DB  cross reference file. ( RCLDBXREF *CHECK never identified it as an error; therefore IBM wouldn't let us run reclaim storage on the database xref file).  I still don't know what is a FILE type "CL" , but it's no longer a problem.

    850 pointsBadges:
    report
  • TheRealRaven
    ...IBM wouldn't let us run reclaim storage on the database xref file...

    "Reclaim storage"? On the database xref file? Did you really mean "reclaim storage? Or was that supposed to be "reclaim DB xref"?

    And could you please clarify what "IBM wouldn't let us" means?
    28,925 pointsBadges:
    report
  • TheRealRaven
    BTW, I would've run RCLDBXREF soon after finding anything that couldn't be explained in the DB xref.
    28,925 pointsBadges:
    report
  • Modiyooch
    TheRealRaven,   I wanted to run RCLDBXREF on one specific library from the beginning,  The company would not let us run it without IBM's blessing.

    From Global Support:

      -  option *fix,  you use that only if we recommend it.  That option is to fix the cross reference file problem you are having.   But please get us the joblog and let us check it out first before giving you the ok to run the *fix.

    option *check did not reveal any errors. I didn't get the go ahead to run the command. We ended up with a work around, and I still don't know what a file type CL is.   It will remain a mystery.
    The application wouldn't run because the system wouldn't allow for a duplicate file name.  The only place the file existed was in the cross reference file.  
    850 pointsBadges:
    report
  • TheRealRaven
    @Modiyooch : It's understandable that IBM support persons would be unwilling to recommend any corrective procedure without first reviewing relevant logs. They aren't regularly on site, so they have to study system history whenever a problem appears in any system feature.

    If the site doesn't have an in-house "systems programmer" position, you have to rely on outsiders. Many sites need one, but choose not to. It makes it hard to judge how appropriate the directions are from IBM Support (or any vendor).
    28,925 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: