Usually, you only have to make changes to FROMSQLServer or SQLServer if it is
a MS Cluster or someone named the instance something different than the
hostname. Also, some may want to knock LOGPrune down from 60 days.

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Howard Coles
Sent: Thursday, March 06, 2008 3:32 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] tdpsql.cfg

Here's the contents (with node names changed to protect the guilty :-):

BEGIN FILE:

BUFFers     3
BUFFERSIze     1024
FROMSQLserver     NODENAME\DBNAME
SQLAUTHentication     INTegrated
SQLBUFFers     0
SQLBUFFERSIze     1024
SQLSERVer     NODENAME\DBNAME
STRIPes     1

LOGFile                  tdpsql.log
LOGPrune     60

MOUNTWaitfordata     Yes
DIFFESTimate     20

LASTPRUNEDate     09/11/2007 08:11:31
LANGuage     ENU

END FILE

Someone may see something that could be tweaked, (I haven't looked at
these files in a very long time) but this is basically what's working on
our SQL Servers (including one 3 node Cluster).

See Ya'
Howard

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Gill, Geoffrey L.
Sent: Thursday, March 06, 2008 3:13 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] tdpsql.cfg

I have been looking for a sample tdpsql.cfg to show how things are laid
out in this file but have found nothing so far. Sure I could just throw
things in it to see if they take but was hoping someone had a link or
one they wouldn't mind sending instead. Any help is appreciated.

 

Thanks,

 

 

Geoff Gill
TSM Administrator
PeopleSoft Sr. Systems Administrator
SAIC M/S-G1b
(858)826-4062
Email: geoffrey.l.gill AT saic DOT com 

-----------------------------------------
Confidentiality Notice:
The information contained in this email message is privileged and
confidential information and intended only for the use of the
individual or entity named in the address. If you are not the
intended recipient, you are hereby notified that any dissemination,
distribution, or copying of this information is strictly
prohibited. If you received this information in error, please
notify the sender and delete this information from your computer
and retain no copies of any of this information.