1;m;Tables/Views within Database;Select distinct creator from SYSIBM.SYSTABLES;Schema;1500;
2;m;Tables (only) within Database;Select distinct creator from SYSIBM.SYSTABLES where type = 'T';Schema;1500;
3;m;Packages within Database;Select distinct collid from sysibm.syspackage;Collid;1200;
4;m;Triggers within Database;Select distinct schema from sysibm.systriggers;Schema;1200;
5;m;Tablespaces within Database;Select NAME from SYSIBM.SYSDATABASE;Database;1200;
6;m;Indexes within Database; Select distinct creator from SYSIBM.SYSINDEXES;Creator;1200;
'7;m;Plans within Database;Select distinct creator from SYSIBM.SYSPLAN;Creator;1200;
8;m;Users within Database;Select distinct grantee from SYSibm.syspackAUTH where granteetype = '' union select distinct grantee from SYSibm.sysTABAUTH where granteetype = '' union select distinct grantee from SYSibm.sysdbaUTH where granteetype = '';Creator;1200;
9;m;Tables within Schema;Select name, type, substr(remarks,1,50) from sysibm.systables where creator = ? and type = 'T' order by 1;Table;2000;Type;1;Desc;3500;
10;m;Tables/Views within Schema;Select name, type, substr(remarks,1,50) from sysibm.systables where creator = ? order by 1;Table;2000;Type;500;Desc;3500;
11;s;Full details of;Select * from sysibm.systables where creator=? and name=?;Column;1500;Value;3000;
12;m;Indexes on;Select creator,name,uniquerule,colcount,clustering from sysibm.sysindexes where tbcreator= ? and tbname=? order by 1,2;Ind Schema;1500;Ind Name;2000;Type;500;#Cols;800;Cluster;800;
13;m;Objects comprising View;Select BCREATOR, BNAME, BTYPE from SYSIBM.SYSVIEWDEP where dcreator=? and dname=? order by 1,2;Schema;1500;Name;2500;Type;800;
14;m;Packages using;Select dcollid,dname from SYSIBM.SYSPACKDEP where bqualifier = ? and bname=? order by 1,2;Pkg Schema;1500;Pkg Name;2000;
15;m;Access list for;Select distinct grantee, selectauth, updateauth, insertauth, deleteauth from sysibm.systabauth where tcreator = ? and ttname=? order by grantee;Userid;1500;Select;600;Update;600;Insert;600;Delete;600;
16;m;Views on;Select dcreator, dname from SYSIBM.SYSVIEWDEP where bcreator=? and bname=? order by 1,2;View Schema;1500;View Name;2500;
18;m;Indexes for creator;Select NAME,TBCREATOR,TBNAME,UNIQUERULE from SYSIBM.SYSINDEXES WHERE CREATOR=? order by 1;Index Name;2000;Tab Creator;1500;Tab Name;2000;Unique;800;
17;v;Definition of view;Select TEXT, seqno from SYSIBM.SYSVIEWS WHERE CREATOR=? AND NAME=? order by seqno;View Text;5000;
19;m;Plans within database;Select NAME,VALID,OPERATIVE from SYSIBM.SYSPLAN;Name;1500;Valid;800;Operative;800;
20;c;Column list for;SELECT NAME, COLTYPE, length, SCALE, NULLS,remarks,colno,substr(defaultvalue,1,20) FROM SYSIBM.SYSCOLUMNS WHERE TBCREATOR=? and TBNAME=? order by colno;Name;2000;Type;1000;Length;650;Scale;500;Nulls;500;Desc;3000;Default;2500;
21;s;Details of package;Select * from sysibm.syspackage where collid = ? and name = ?;Column;1500;Value;3000;
22;m;Objects used by Package;Select bqualifier,bname, btype from SYSIBM.SYSPACKDEP where dcollid=? and dname=? order by 1,2;Schema;1500;Name;2000;Type;1000;
23;m;Statements in package;Select SECTNO,STMTNO, SEQNO, substr(STMT,9,200) from SYSIBM.SYSPACKSTMT where collid=? and name=? order by 1,2,3;Section;700;Stmt;600;Seq;500;Text;8000;
24;m;Access list for package;Select GRANTEE, GRANTEETYPE, executeauth, COPYAUTH, BINDAUTH from SYSIBM.SYSPACKAUTH where collid=? and name=? order by grantee;Id;1500;Id Type;800;Execute;800;Bind;800;Copy;800;
25;s;Details of trigger;Select * from SYSIBM.SYSTRIGGERS where schema=? and name=? and seqno=1;Column;1500;Value;5000;
26;m;Procedures within Database;Select distinct schema, schema from sysibm.sysroutines where routinetype='P';Schema;1200;
27;m;Procedures within Schema;Select name, parm_count, substr(remarks,1,50),specificname from sysibm.sysroutines where schema = ? and routinetype='P' order by 1;Name;2000;Num Parms;800;Desc;3500;Specificname;1;
28;P2;Parameters for;select PARMNAME, ROWTYPE, TYPENAME, LENGTH, SCALE, LOCATOR From SYSIBM.SYSPARMS Where SCHEMA=? AND SPECIFICNAME=? and routinetype='P' Order By ORDINAL;Parm;1500;Mode;800;Type;1000;Length;800;Scale;800;Locator;800;
'28;O;Parameters for procedure;B;Parm;1500;Mode;800;Type;1000;Length;800;Scale;800;
29;s2;Full details of;Select * from sysibm.sysroutines Where SCHEMA=? AND SPECIFICNAME=? and routinetype='P';Column;1500;Value;3000;
31;m;Tables (only) within Schema;Select tabname, type, substr(remarks,1,50) from sysibm.systables where creator = ? and type='T' order by 1;Table;2000;Type;1;Desc;3500;
32;m;Packages within Collid;Select NAME, valid, operative from SYSIBM.SYSPACKAGE where collid=? order by 1;Name;1500;Valid;800;Operative;800;
33;m;Triggers within Schema;Select NAME,REMARKS from SYSIBM.SYSTRIGGERS where schema=? order by 1;Name;1500;Desc;2500;
34;d;Contents of;Anything;Name;1500;
35;m;Statements in Plan;Select NAME,SECTNO,STMTNO, SEQNO, substr(TEXT,9,200) from SYSIBM.SYSSTMT where plname=? order by 1,2,3;DBRM;1200;Section;700;Stmt;600;Seq;500;Text;8000;
36;m;Packages in Plan;Select COLLID, NAME, LOCATION, TIMESTAMP, SEQNO from SYSIBM.SYSPACKLIST WHERE PLANNAME=? ORDER BY SEQNO;Collid;1500;Package;1200;Location;1200;Timestamp;1800;Seq;800;
37;m;Functions within Database;Select distinct schema, schema from sysibm.sysroutines where routinetype='F';Schema;1200;
38;m;Functions within Schema;Select name, parm_count, substr(remarks,1,50),specificname from sysibm.sysroutines where schema = ? and routinetype='F' order by 1;Name;2000;Num Parms;800;Desc;3500;specificname;1;
40;m;Tablespaces within Database;Select NAME, NACTIVE, NTABLES from SYSIBM.SYSTABLESPACE WHERE DBNAME=? order by 1;Name;2000;Pages;800;#Tables;1000;
41;s;Details of tablespace;Select * from sysibm.systablespace where dbname=? and name=?;Column;1500;Value;3000;
42;m;Tables within tablespace;Select CREATOR, NAME, REMARKS from SYSIBM.SYSTABLES WHERE DBNAME=? AND TSNAME=? and type='T';Schema;1500;Table;2000;Desc;3500;
43;m;Sizing for tables within tablespace;Select CREATOR, NAME, CARD, NPAGES from SYSIBM.SYSTABLES WHERE DBNAME=? AND TSNAME=? order by npages desc;Schema;1500;Table;2000;Rows;800;Pages;800;
44;m;Partitions within tablespace;Select PARTITION,PQTY,SQTY,STORNAME,CARD,SPACE,PERCACTIVE,COMPRESS,CHECKFLAG from SYSIBM.SYSTABLEPART WHERE DBNAME=? and TSNAME=?;Part;800;PriQty;800;SecQty;800;StoName;1500;Rows;1000;Space(KB);1000;Act Pages;1000;Compress;800;Check-Pending;800;
45;s;Details of index;Select * from sysibm.sysindexes where creator=? and name=?;Column;1500;Value;3000;
46;m;Partitions within index;Select PARTITION,PQTY,SQTY,STORNAME,CARD,SPACE from SYSIBM.SYSINDEXPART WHERE ixCREATOR=? and ixNAME=?;Part;800;PriQty;800;SecQty;800;StoName;1500;Rows;1000;
47;m;Columns in index;Select COLNAME, COLSEQ, ORDERING from SYSIBM.SYSKEYS where IXCREATOR=? and IXNAME = ? order by 1;Column;2000;Seq;800;Ordering;800;
48;s;Details of plan;Select * from sysibm.sysplan where name=?;Column;1500;Value;3000;
49;m;Access list for plan;Select distinct GRANTEE, executeauth, BINDAUTH from SYSIBM.SYSPLANAUTH where name=? order by grantee;Id;1500;Execute;800;Bind;800;
50;m;Objects used by plan;Select BCREATOR, BNAME, BTYPE from SYSIBM.SYSPLANDEP WHERE DNAME=?;Schema;1500;Name;1200;Type;800;
51;w;Definition of view;Select TEXT, seqno from SYSIBM.SYSVIEWS WHERE CREATOR=? AND NAME=? order by seqno;Seq;800;Text;5000;
52;m;Views within Database;Select distinct creator from SYSIBM.SYSTABLES where type = 'V';Schema;1500;
53;m;Views within Schema;Select name, type, substr(remarks,1,50) from sysibm.systables where creator = ? and type = 'V' order by 1;View;2000;Type;1;Desc;3500;
60;a;Table authorities for;Select distinct tcreator, ttname, selectauth, updateauth, insertauth, deleteauth, alterauth, referencesauth, indexauth from sysibm.systabauth where grantee = ? order by 1,2;Schema;1200;Name;1800;Select;600;Update;700;Insert;600;Delete;600;Alter;500;References;800;Index;600;
61;b;Table authorities for;Select distinct tcreator, ttname,grantor, selectauth, updateauth, insertauth, deleteauth, alterauth, referencesauth, indexauth from sysibm.systabauth where grantee = ? order by 1,2;Schema;1200;Name;1800;Grantor;1000;Select;600;Update;700;Insert;600;Delete;600;Alter;500;References;800;Index;600;
62;m;Plan authorities for;Select distinct name, executeauth, BINDAUTH from SYSIBM.SYSPLANAUTH where grantee=? order by name;Plan;1500;Execute;800;Bind;800;
63;m;Package authorities for;Select collid, name, GRANTEETYPE, executeauth, COPYAUTH, BINDAUTH from SYSIBM.SYSPACKAUTH where GRANTEE=? order by grantee;Collid;1200;Package;1500;Id Type;800;Execute;800;Bind;600;Copy;600;
64;m;Database authorities for;Select distinct NAME, CREATETABAUTH, CREATETSAUTH, DBMAINTAUTH, DBCTRLAUTH DBADMAUTH from SYSIBM.SYSDBAUTH WHERE GRANTEE=? order by 1;Database;1200;CreateTab;900;CreateTS;800;DBMaint;800;DBCtrl;800;DBAdm;800;
65;u;Users within Database;select distinct grantee from SYSibm.sysTABAUTH where granteetype = '' ;Creator;1200;
66;m;Packages using index;Select dcollid,dname from SYSIBM.SYSPACKDEP where bqualifier=? and bname=? and btype='I' order by 1,2;Schema;1500;Name;2000;
67;q;View as Query;Select TEXT, seqno from SYSIBM.SYSVIEWS WHERE CREATOR=? AND NAME=? order by seqno;Seq;800;Text;5000;
68;f;Column list for Alias;SELECT col.NAME, col.COLTYPE, col.LENGTH, col.SCALE, col.NULLS, col.REMARKS, col.COLNO, substr(col.defaultvalue,1,20) FROM SYSIBM.SYSCOLUMNS col, SYSIBM.SYSTABLES tab WHERE tab.TBCREATOR=col.TBCREATOR AND tab.TBNAME=col.TBNAME AND tab.CREATOR = ? AND tab.NAME = ? order by col.colno;Name;2000;Type;1000;Length;650;Scale;500;Nulls;500;Desc;3000;Default;2500;
69;X;Text of trigger;Select TEXT, seqno from SYSIBM.SYSTRIGGERS where schema=? and name=? order by seqno;Text;6000;
70;P2;Parameters for;select PARMNAME, ROWTYPE, TYPENAME, LENGTH, SCALE, LOCATOR From SYSIBM.SYSPARMS Where SCHEMA=? AND SPECIFICNAME=? and routinetype='F' Order By ORDINAL;Parm;1500;Mode;800;Type;1000;Length;800;Scale;800;Locator;800;
71;s2;Full details of;Select * from sysibm.sysroutines Where SCHEMA=? AND SPECIFICNAME=? and routinetype='F';Column;1500;Value;3000;