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 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 [EMAIL PROTECTED] > >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 > >********************************************************************************
