Some tables that are selectable seem to not have syscat.columns entries.

processes
status
paths
mgmtclasses
cloptsets
clientopts
scripts
stgspacetrigger
collocgroup
datamovers
disks
drmsrpf
group_member
spcmgfiles

So I can do a 
SELECT * FROM MGMTCLASSES
successfully, but not a 
SELECT COLNAME FROM SYSCAT.COLUMNS WHERE TABNAME='MGMTCLASSES'

I know there are some "view" tables (nodes, filespaces), and some
related tables MANAGEMENT_CLASSES, but how do you get the column names
for the tables listed above?  (besides doing a full select on the
table.)

ANS8000I Server command: 'select * from mgmtclasses'
     DOMAIN_NAME: STANDARD
        SET_NAME: ACTIVE
      CLASS_NAME: STANDARD
       DEFAULTMC: No
     DESCRIPTION: Installed default management class.
SPACEMGTECHNIQUE: NONE
   AUTOMIGNONUSE: 0
 MIGREQUIRESBKUP: YES
  MIGDESTINATION: SPACEMGPOOL
        CHG_TIME: 2009-05-01 15:53:33.000000
       CHG_ADMIN: SERVER_CONSOLE
         PROFILE:

ANS8000I Server command: 'select colname from syscat.columns where
tabname='MGMTCLASSES'
ANR2034E SELECT: No match found using this criteria.
ANS8001I Return code 11.

ANS8000I Server command: 'select colname from syscat.columns where
tabname='MANAGEMENT_CLASSES''
COLNAME: DOMAINNAME
COLNAME: SETNAME
COLNAME: MCNAME
COLNAME: MCID
COLNAME: MC_DESCR
COLNAME: UPDATE_DATE
COLNAME: UPDATOR
COLNAME: SPACEMGMT_TECHNIQUE
COLNAME: AUTOMIGINUSE
COLNAME: MIGREQBKUP
COLNAME: MIGDEST
COLNAME: CHG_PENDING

Thanks.



The information contained in this transmission may contain privileged and 
confidential information. 
It is intended only for the use of the person(s) named above. If you are not 
the intended  
recipient, you are hereby notified that any review, dissemination, distribution 
or  
duplication of this communication is strictly prohibited. If you are not the 
intended recipient, 
please contact the sender by reply email and destroy all copies of the original 
message. 
To reply to our email administrator directly, please send an email to 
postmaster AT sbsplanet DOT com.