Ilja,
Let the system work for you.
Try:
adsm> select * from tables
TABSCHEMA: ADSM
TABNAME: ACTLOG
CREATE_TIME: 1997-10-22 11:50:12.000000
COLCOUNT: 11
INDEX_COLCOUNT: 1
UNIQUE_INDEX: FALSE
REMARKS: Server activity log
TABSCHEMA: ADSM
TABNAME: ADMINS
CREATE_TIME: 1997-10-22 11:50:12.000000
COLCOUNT: 17
INDEX_COLCOUNT: 1
UNIQUE_INDEX: TRUE
REMARKS: Server administrators
TABSCHEMA: ADSM
TABNAME: ADMIN_SCHEDULES
CREATE_TIME: 1997-10-22 11:50:12.000000
COLCOUNT: 16
INDEX_COLCOUNT: 1
UNIQUE_INDEX: TRUE
more... (<ENTER> to continue, 'C' to cancel) c
The entire output is the complete list of tables
Then:
adsm> select * from columns
TABSCHEMA: ADSM
TABNAME: ACTLOG
COLNAME: DATE_TIME
COLNO: 1
INDEX_KEYSEQ: 1
INDEX_ORDER: A
TYPENAME: TIMESTAMP
LENGTH: 0
SCALE: 0
NULLS: FALSE
REMARKS: Date/Time
TABSCHEMA: ADSM
TABNAME: ACTLOG
COLNAME: MSGNO
COLNO: 2
INDEX_KEYSEQ:
INDEX_ORDER:
TYPENAME: INTEGER
LENGTH: 0
SCALE: 0
NULLS: FALSE
more... (<ENTER> to continue, 'C' to cancel) c
That gives you the set of column names in each table.
Finally, you'll need:
adsm> select * from enumtypes
TYPEINDEX: 0
TYPENAME: OBJECT_TYPE
VALUECOUNT: 3
VALUES: DIR(0), FILE(1), UNKNOWN(2)
REMARKS: Object Type
TYPEINDEX: 1
TYPENAME: BACKUPSTATE
VALUECOUNT: 3
VALUES: ACTIVE_VERSION(0), INACTIVE_VERSION(1), UNKNOWN(2)
REMARKS: Backup object version state
TYPEINDEX: 2
TYPENAME: YESNO_TYPE
VALUECOUNT: 3
VALUES: NO(0), YES(1), UNCERTAIN(2)
REMARKS: Yes/No Enumeration
TYPEINDEX: 3
TYPENAME: COMPRESSTYPE
VALUECOUNT: 3
VALUES: NO(0), YES(1), CLIENT(2)
more... (<ENTER> to continue, 'C' to cancel) c
since not all DB values are text. The enumtypes table gives the list of
selectable values for non-text and non-numeric values.
I used MS Access to connect to the ADSM DB via ODBC, and created a
nicely-formatted report listing all tables, column names, data type, length, and
descriptions.
It has come in VERY handy!
Good luck.
Tab
"Ilja G. Coolen" <ilja.coolen AT MAIL.ABP DOT NL> on 02/08/2000 08:21:45 AM
Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
cc: (bcc: Tab Trepagnier/Corporation/Laitram/US)
Subject: Request for SQL reference.
Hi.
Does any of you *SM SQL guru's have an SQL reference on the *SM database?
I can't seem to get more information out of our database at this time. I'm
am no SQL wizzard either.
Perhaps, with help from you guys (girls), i can slightly become a better *SM
admin.
T.I.A.
Kind regards,
___________________________________________________
Ilja G. Coolen
ABP / USZO / CIS / ES / Storage Management
Tel: +31 (0)45 579 7938
Fax: +31 (0)20 882 7286
Email : ilja.coolen AT abp DOT nl
|