Help output examples

Edit online

These output examples provide a sample of the text, messages, and process status that displays when using the help command.

Help 1-Query TSM

Command:

tdpsqlc help query tsm *

Output:

IBM Storage Protect for Databases:
Data Protection for Microsoft SQL Server
Version 8, Release 1, Level 0
(C) Copyright IBM Corporation 1998, 2016.
All rights reserved.

TDPSQLC Query TSM *|dbname[,dbname,...] [*]
 [/ACtive]
 [/ALl]
 [/BUFFers=numbuffers]              default: 3    (or cfg value)
 [/BUFFERSIze=buffersizeinkb]       default: 1024 (or cfg value)
 [/COMPATibilityinfo]
 [/CONFIGfile=configfilename]       default: tdpsql.cfg
 [/FROMSQLserver=sqlservername]     default: sqlserver value (or cfg value)
 [/LOGFile=logfilename]             default: tdpsql.log (or cfg value)
 [/LOGPrune=numdays|No]             default: 60   (or cfg value)
 [/OBJect=*|objectname[,objectname,...]]
 [/TSMNODe=tsmnodename]             default: dsm.opt value
 [/TSMOPTFile=dsmoptfilename]       default: dsm.opt
 [/TSMPassword=tsmpassword]         default: dsm.opt value

Help 2-Restore Full

Command:

tdpsqlc help rest full

Output:

IBM Storage Protect for Databases:
Data Protection for Microsoft SQL Server
Version 8, Release 1, Level 0
(C) Copyright IBM Corporation 1998, 2016.
All rights reserved.

TDPSQLC Restore *|dbname[,dbname,...]  [Full]
 [/BACKUPDESTination=TSM|LOCAL]     default: TSM
 [/BACKUPMETHod=LEGACY|VSS]         default: LEGACY
 [/BUFFers=numbuffers]              default: 3    (or cfg value)
 [/BUFFERSIze=buffersizeinkb]       default: 1024 (or cfg value)
 [/CONFIGfile=configfilename]       default: tdpsql.cfg
 [/DBOonly]
 [/FIles=*|logicalname[,logicalname,...] ]
 [/FROMSQLserver=sqlservername]     default: sqlserver value (or cfg value)
 [/GRoups=*|groupname[,groupname,...] ]
 [/INSTANTRestore=Yes|No]           default: Yes 
 [/INTO=dbname]
 [/LOGFile=logfilename]             default: tdpsql.log (or cfg value)
 [/LOGPrune=numdays|No]             default: 60   (or cfg value)
 [/OBJect=*|objectname[,objectname,...] ]
 [/PARTial]
 [/Quiet]
 [/RECOVery=Yes|No]                 default: Yes
 [/RELocate=lname /TO=pname [/RELocate=lname /TO=pname ...] ]
 [/RELOCATEDir=directory[,logfiledirectory[,otherfiledirectory]] ]
 [/REPlace]
 [/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=[sqlserver-connection]
                                    default: local computer name (or cfg value)
                                    default sqlprotocol: "" (or cfg value)
 [/SQLUSer=sqlusername]             default: sa
 [/STANDby=undofilename]
 [/STRIPes=numstripes]              default: 1   (or cfg value)
 [/TSMNODe=tsmnodename]             default: dsm.opt value
 [/TSMOPTFile=dsmoptfilename]       default: dsm.opt
 [/TSMPassword=tsmpassword]         default: dsm.opt value

Help 3-Restore Log

Command:

tdpsqlc help rest log

Output:

IBM Tivoli Storage Manager for Databases:
Data Protection for Microsoft SQL Server
Version 7, Release 1, Level 3.0
(C) Copyright IBM Corporation 1998, 2015.
All rights reserved.

TDPSQLC Restore *|dbname[,dbname,...]  Log=*|logobjectname[,logobjectname,...]
 [/BUFFers=numbuffers]              default: 3    (or cfg value)
 [/BUFFERSIze=buffersizeinkb]       default: 1024 (or cfg value)
 [/CONFIGfile=configfilename]       default: tdpsql.cfg
 [/DBOonly]
 [/FROMSQLserver=sqlservername]     default: sqlserver value (or cfg value)
 [/INTO=dbname]
 [/LOGFile=logfilename]             default: tdpsql.log (or cfg value)
 [/LOGPrune=numdays|No]             default: 60   (or cfg value)
 [/OBJect=*|objectname[,objectname,...] ]
 [/Quiet]
 [/RECOVery=Yes|No]                 default: Yes
 [/RELocate=lname /TO=pname [/RELocate=lname /TO=pname ...] ]
 [/RELOCATEDir=directory[,logfiledirectory[,otherfiledirectory]] ]
 [/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=[sqlserverconnection]
                                    default: local computer name (or cfg value)
                                    default sqlprotocol: "" (or cfg value)
 [/SQLUSer=sqlusername]             default: sa
 [/STANDby=undofilename]
 [/STOPAT=datetime]
 [/STOPATMark=markname [/AFTER=datetime] ]
 [/STOPBEFOREMark=markname [/AFTER=datetime] ]
 [/STRIPes=numstripes]              default: 1   (or cfg value)
 [/TSMNODe=tsmnodename]             default: dsm.opt value
 [/TSMOPTFile=dsmoptfilename]       default: dsm.opt
 [/TSMPassword=tsmpassword]         default: dsm.opt value

Help 4-Set

Command:

tdpsqlc help set

Output:

IBM Tivoli Storage Manager for Databases:
Data Protection for Microsoft SQL Server
Version 7, Release 1, Level 3.0
(C) Copyright IBM Corporation 1998, 2015.
All rights reserved.

TDPSQLC Set PARMname=value
  [/CONFIGfile=configfilename]      default: tdpsql.cfg
  
  where PARMname and possible values are:
     BACKUPDESTination=[TSM|LOCAL|BOTH]
     BACKUPMETHod=[LEGACY|VSS]
     BUFFers=numbuffers          (2..8)
     BUFFERSIze=buffersize       (64..8192)
     DATEformat=dateformatnum
       1    MM/DD/YYYY
       2    DD-MM-YYYY
       3    YYYY-MM-DD
       4    DD.MM.YYYY
       5    YYYY.MM.DD
       6    YYYY/MM/DD
       7    DD/MM/YYYY
     DIFFESTimate=numpercent     (1..99)
     FROMSQLserver=sqlservername
     LANGUAGE=3-letter country code
       ENU     American English
       PTB     Brazilian Portuguese
       CHS     Chinese, Simplified
       CHT     Chinese, Traditional
       FRA     Standard French
       DEU     Standard German
       ITA     Standard Italian
       JPN     Japanese
       KOR     Korean
       ESP     Standard Spanish
     LOCALDSMAgentnode=nodename
     LOGFile=logfilename
     LOGPrune=[numdays|No]       (0..9999) | No
     NUMBERformat=numberformatnum
       1    n,nnn.dd
       2    n,nnn,dd
       3    n nnn,dd
       4    n nnn.dd
       5    n.nnn,dd
       6    n'nnn,dd
     REMOTEDSMAgentnode=nodename
     SQLAUTHentication=[INTegrated|SQLuserid] 
     SQLBUFFers=numsqlbuffers    (0..999)
     SQLBUFFERSIze=sqlbuffersize (64..4096)
     SQLSERVer=[sqlprotocol:]sqlservername
     STRIPes=numstripes          (1..64)
     TIMEformat=timeformatnum
       1    HH:MM:SS
       2    HH,MM,SS
       3    HH.MM.SS
       4    HH:MM:SSA/P