ADSM-L

Re: Request for SQL reference.

2000-02-08 09:41:02
Subject: Re: Request for SQL reference.
From: Tab Trepagnier <Tab.Trepagnier AT LAITRAM DOT COM>
Date: Tue, 8 Feb 2000 08:41:02 -0600
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
<Prev in Thread] Current Thread [Next in Thread>