Hello, Perhaps someone could help here...
TSM Server is 5.1.5.2 TSM Client is 5.1.5.0 on Windows NT UDB7 installed I have a UDB7 database on a Windows NT server. I have performed all of the actions required to backup the database and have backed it up several times from either the UDB7 Control Centre or via a batch file that executes UDB7 commands. I backup the database to TSM My batch file looks like this: CD\ CD SQLLIB\BIN START /B DB2CMD DB2 BACKUP DATABASE database-name ONLINE USE TSM I want to back this up via a TSM schedule using the command option. I point the client schedule to the location of the batch file that contains the above command. I have a scheduled service on the NT box, pointing to the correct options file. I have the options file set to prompted and the schedule runs fine, except that i see a DB2 Command Line Client screen with message 'SQL0567N "SYSTEM" IS NOT A VALID AUTHORIZATION ID - SQLSTATE=42602' All of our TSM scheduled services use the SYSTEM account, including our many TDP agents and all are fine. I have the documentation 'Backing Up DB2 Using Tivoli Storage Manager' and it refers specifically to UNIX and WINDOWS 2000. There is no specific reference to NT - is it fully supported on Windows NT clients? I am aware that there is a scheduling function within UDB7 Control Centre and that this would schedule the backup for me. But my preference is via TSM schedule because it gives me a greater degree of control Thanks Jeff White Senior Systems Programmer CIS [EMAIL PROTECTED] ************************************************************************* 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 ********************************************************************************
