see
      http://www-1.ibm.com/support/entdocview.wss?uid=swg21050781
for more information...
Disclaimer : I DO NOT ENCOURAGE MESSING WITH THE TSM DB, USE AT YOUR OWN
RISK !!
but this will get you close to what you desire...
Oh, to see all the things you can be VERY DANGEROUS WITH and use with the
create sqltable command... use ~show objects~ debug command...
I will point out that this information is nothing beyond what is currently
publically available through the adsm-l archives (the possible show
commands) and public web pages on TSM...

tsm: >create sqltable Authorization.Rules azrule
SQL table azrule created to map base table Authorization.Rules.

tsm: >select * from azrule

  C0: 88
  C1: EORA
  C2: 5
  C3: 2
  C4: 0
  C5: /
  C6:
  C7: XYZASTD1
  C8: oracle
  C9:
 C10:
 C11:
PAGE: 72

  C0: 88
  C1: EORA
  C2: 6
  C3: 2
  C4: 0
  C5: /
  C6:
  C7: XYZASTD1
  C8: EORA
  C9:
 C10:
 C11:
PAGE: 72

  C0: 88
  C1: astar
  C2: 9
  C3: 2
  C4: 0
  C5: /
  C6:
  C7: ABCDEVA1
  C8: astar
  C9:
 C10:
 C11:
PAGE: 72

<...etc...>

to clear up your table...

tsm: >drop sqltable azrule
SQL table AZRULE dropped.

tsm: >





                      Bill Kelly
                      <[EMAIL PROTECTED]        To:       [EMAIL PROTECTED]
                      URN.EDU>                 cc:
                      Sent by: "ADSM:          Subject:  User access list information
                      Dist Stor
                      Manager"
                      <[EMAIL PROTECTED]
                      .EDU>


                      06/04/2003 08:21
                      AM
                      Please respond to
                      "ADSM: Dist Stor
                      Manager"






Hi,

Does anyone know where the information is kept when a client node grants
access to its data to some other node?  I've looked in the column names
and remarks for bunches of tables in the TSM server db and haven't found
anything.  I'm assuming that's where the info is kept? Couldn't find
anything in the list archives, either...

Thanks,
Bill

Bill Kelly
Auburn University
334-844-9917

Reply via email to