ADSM-L

Re: TDP for SQL/upgrade not working.

2003-01-28 12:22:45
Subject: Re: TDP for SQL/upgrade not working.
From: Del Hoobler <hoobler AT US.IBM DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 28 Jan 2003 12:22:57 -0500
Geoff,

Could it be:
   /sqlpwd=adsm
should be:
   /SQLPassword=adsm

or... it could be that the new TSM API removed some
of the old communications options.. which means
you may have to remove the old options out
of the DSM.OPT file.

Here is the syntax:

TDPSQLC Backup *|dbname[,dbname,...]  [Full]
 [/BUFFers=numbuffers]              default: 3    (or cfg value)
 [/BUFFERSIze=buffersizeinkb]       default: 1024 (or cfg value)
 [/CONFIGfile=configfilename]       default: tdpsql.cfg
 [/LOGFile=logfilename]             default: tdpsql.log (or cfg value)
 [/LOGPrune=numdays|No]             default: 60   (or cfg value)
 [/MOUNTWait=Yes|No]                default: Yes  (or cfg value)
 [/Quiet]
 [/SQLAUTHentication=INTegrated|SQLuserid] default: INTegrated (or cfg
value)
 [/SQLBUFFers=numsqlbuffers]        default: 0    (or cfg value)
 [/SQLBUFFERSIze=sqlbuffersizeinkb] default: 1024 (or cfg value)
 [/SQLPassword=sqlpasswordname]     default: " "
 [/SQLSERVer=sqlservername]         default: local computer name (or cfg
value)
 [/SQLUSer=sqlusername]             default: sa
 [/STRIPes=numstripes]              default: 1    (or cfg value)
 [/TSMNODe=tsmnodename]             default: dsm.opt value
 [/TSMOPTFile=dsmoptfilename]       default: dsm.opt
 [/TSMPassword=tsmpassword]         default: dsm.opt value

Thanks,

Del

----------------------------------------------------

Del Hoobler
IBM Corporation
hoobler AT us.ibm DOT com

- Never cut what can be untied.
- Commit yourself to constant improvement.

==========================

> I've upgraded to TDP for SQL 5.1 and backups have now quit working. There
> are some invalid options messages when running the SQL.cmd file. The link
> below does not have a version 5 manual listed. Can anyone point me to one
so
> I can figure out what line here is causing the proplem.
>
> tdpsql backup * full /sqluser=adsm_user /sqlpwd=adsm
> /logfile=c:\Logs\sqlfull.log  /tsmoptfile=dsm.opt

<Prev in Thread] Current Thread [Next in Thread>