Jeff,
I unload some of the tsm tables daily and then load them into db2.
The method will depend on your server platform and the target dbms.
My server is on OS/390 and the target is db2. Briefly the process
is a batch job that does 'select * from nodes' with the output
going to a file. the file is massaged to make it db2 loadable, then the
file is passed to the db2 load utility. I do this daily for nodes, filespaces
and associations, weekly for occupancy.
Just this week I was asked to analyze the effects of changing the copygroup
parameters. I am doing this by 'select <columns> from backups' for some
randomly chosen filespaces, then loading the output into db2.
If you want more info you can email me directly.
----------
Bill Colwell
Bill Colwell
C. S. Draper Lab
Cambridge Ma.
At 04:24 PM 4/17/2002 +0000, you wrote:
>I have read a document presented at a SHARE conference in July 2001in
>relation to the TSM database structure. In the SQL section of that
>document, there is mention of a method to "unloading to a true relational
>database for
>complicated query processing". However, the document does not describe the
>method. Anyone out there have a suggestion as to how we can achieve this.
>
>The document was written by Dave Cannon from the TSM development team
>
>Thanks
>
>Jeff White
>
>*************************************************************************
>
>This e-mail may contain confidential information or be privileged. It is
>intended to be read and used only by the named recipient(s). If you are not
>the intended recipient(s) please notify us immediately so that we can make
>arrangements for its return: you should not disclose the contents of this
>e-mail to any other person, or take any copies. Unless stated otherwise by an
>authorised individual, nothing contained in this e-mail is intended to create
>binding legal obligations between us and opinions expressed are those of the
>individual author.
>
>The CIS marketing group, which is regulated for Investment Business by the
>Financial Services Authority, includes:
>Co-operative Insurance Society Limited Registered in England number 3615R -
>for life assurance and pensions
>CIS Unit Managers Limited Registered in England and Wales number 2369965 -
>for unit trusts and PEPs
>CIS Policyholder Services Limited Registered in England and Wales number
>3390839 - for ISAs and investment products bearing the CIS name
>Registered offices: Miller Street, Manchester M60 0AL Telephone
>0161-832-8686 Internet http://www.cis.co.uk E-mail cis AT cis.co DOT uk
>
>CIS Deposit and Instant Access Savings Accounts are held with The Co-operative
>Bank p.l.c., registered in England and Wales number 990937, P.O. Box 101, 1
>Balloon Street, Manchester M60 4EP, and administered by CIS Policyholder
>Services Limited as agent of the Bank.
>
>CIS is a member of the General Insurance Standards Council
>
>CIS & the CIS logo (R) Co-operative Insurance Society Limited
>
>********************************************************************************
|