DB2 expire script for TSM

Hi all, I am looking for a script to expire my DB2 backups from TSM after 3 months. Does anyone have such a script? Regards, Jacques van den Berg Pick 'n Pay IT Email : [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Phone : 021-658 1694 Mobile : 082 - 653 8164 Dis altyd l

Re: Sanergy ?

Hi, If I can add my little bit. The TSM support guys from IBM talk us out of it. Support/Managing it is apparently quite a nightmare. Regards, Jacques van den Berg TSM / SAP-Storage Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] Phone : 021-658 1694 Mobile : 082 - 653 8164

SQL2025N An I/O error "-50" occurred on media "TSM".

Hi, I had the above error last night on a DB2 backup. The error point to my "CommTimeOut" parameter which is currently set to 60. Can anyone give me an indication as to what is a good value for this parameter? q option I'm running TSM 5.3 on AIX 5.3 Thanks Jacqu

Re: archive hangs

Hi, My settings for udp (send & receive) are as follow (1GIG Network): udp_sendspace=65536 udp_recvspace=65536 The rest of the settings are the same. Jacques van den Berg TSM / SAP Storage Administrator Pick 'n Pay IT Email   : [EMAIL PROTECTED] Tel  : 021 - 658 1694 Fax :

Re: archive hangs

Hi Ralph, As Kurt said, 40Gig/Hour is about right. I have a schedule that kicks off 16 clients and I still get around 40Gig/hour. Database backups however do MUCH better. Regards, Jacques van den Berg TSM / SAP Storage Administrator Pick 'n Pay IT Email   : [EMAIL PROTECTED] Tel 

Re: Backup DB2 using TSM

Hi, No need to use user exits. DB2 Ver 8.2 and TSM 5.3 Read the Redbook sg246247 - "Backup DB2 using TSM" Chapter 5 Explain everything. We are using many DB2 databases using TSM to do the backups and writing the DB2 logs to TSM as well. Regards, Jacques van den Berg TSM / S

Re: SQL2062N: Reason code =406

Check file permissions for your errorlog file... Jacques van den Berg TSM / SAP Storage Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] Tel : 021 - 658 1711 Fax : 021 - 658 1699 Mobile : 082 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens li

Re: Network tuning question -- AIX to AIX

our environment. Do you recon it is not worth doing it? What issue did you experience? Regards, Jacques van den Berg TSM / SAP Storage Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] Tel : 021 - 658 1711 Fax : 021 - 658 1699 Mobile : 082 - 653 8164 Dis altyd lente in die har

Re: Network tuning question -- AIX to AIX

Re: rfc1323, Yes you right... Setting this to 1 allows you to send big buffers. Jacques van den Berg TSM / SAP Storage Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] Tel : 021 - 658 1711 Fax : 021 - 658 1699 Mobile : 082 - 653 8164 Dis altyd lente in die hart van die men

Re: Network tuning question -- AIX to AIX

Re: rfc1323, Yes you right... Setting this to 1 allows you to send big buffers. no -o rfc1323=1#To apply the setting immediately no -r -o rfc1323=1 #To apply the setting after the next reboot. Regards, Jacques van den Berg TSM / SAP Storage Administrator Pick 'n Pay IT Email : [

Re: Network tuning question -- AIX to AIX

Hi, We get around 65MB/s. The backups to TSM is not optimized as yet. Very are busy implementing a very big SAP landscape at the moment, so some of my node backups are running in parallel to TSM. Regards, Jacques van den Berg TSM / SAP Storage Administrator Pick 'n Pay IT Email : [

Re: TSM on P5 LPAR

Hi Paul, I'm running a TSM server on a P550 with 2 LPAR's - 3CPU's & 12GIG Memory. Running great. Regards, Jacques van den Berg TSM / SAP Storage Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] Tel : 021 - 658 1711 Fax : 021 - 658 1676 Mobile : 082 -

Re: DB2 nodes unable to delete transaction log archives TSM 5.3.2.3

Can you see it the actual log file is in TSM? db2adutl query logs Are you using db2adutl to delete them? Jacques van den Berg TSM / SAP Storage Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] Tel : 021 - 658 1711 Fax : 021 - 658 1676 Mobile : 082 - 653 8164 Dis altyd len

Re: Gig utilization during backups

=65536 no -r -o udp_sendspace=65536 no -o udp_recvspace=65536 no -r -o udp_recvspace=65536 no -o tcp_recvspace=262144 no -r -o tcp_recvspace=262144 no -o tcp_sendspace=262144 no -r -o tcp_sendspace=262144 no -o rfc1323=1 no -r -o rfc1323=1 Hope this help... Jacques van den Berg TSM / SAP

Re: TSM for DB2

It uses an API not TDP. See the Redbook "sg246247 Backup up DB2 on TSM". Regards, Jacques van den Berg TSM / SAP Storage Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] Tel : 021 - 658 1711 Fax : 021 - 658 1676 Mobile : 082 - 653 8164 Dis altyd lente in die ha

Re: DB2 backups

Look at this Redbook : sg246247 Backup up DB2 on TSM. It will explain everything. You don't associate it with a schedule. You do the backup from db2 into TSM. Regards, Jacques van den Berg TSM / Storage / SAP Basis Administrator Pick 'n Pay IT Email   : [EMAIL PROTECTED] Tel  :

Re: DB2 Log Archiving via TSM

to TSM. Regards, Jacques van den Berg TSM / Storage / SAP Basis Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] Tel : +2721 - 658 1711 Fax : +2721 - 658 1676 Mobile : +2782 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens liefhet (John Vi

Re: DB2 - HADR and TSM

Hi Rainer, We backup the primary database as per normal with the db2 command to TSM. We do a full online backup everyday and archive logs to TSM as well. Nothing special. Kind Regards, Jacques van den Berg TSM / Storage / SAP Basis Administrator Pick 'n Pay IT Email : jvandenb...@pnp.

Re: DB2 - HADR and TSM

node. Hope this helps. Kind Regards, Jacques van den Berg TSM / Storage / SAP Basis Administrator Pick 'n Pay IT Email : jvandenb...@pnp.co.za Tel : +2721 - 658 1711 Fax : +2721 - 658 1676 Mobile : +2782 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy med

Restore error - invalid "version id's list" field found in "ObjRtrv" verb

d. (SESSION: 188967) Kind Regards, Jacques van den Berg TSM / Storage / SAP Basis Administrator Pick 'n Pay IT Email : jvandenb...@pnp.co.za <mailto:jvandenb...@pnp.co.za> Tel : +2721 - 658 1711 Fax : +2721 - 658 1676 Mobile : +2782 -

Re: why create a 12TB LUN

Had an original IBM 4.77MHz in 1991. 640KB Main memory. 360K Floppy drive & a 10MB Hard drive. Kind Regards,   Jacques van den Berg TSM / Storage / SAP Basis Administrator Pick 'n Pay IT Email   : jvandenb...@pnp.co.za Tel  : +2721 - 658 1711 Fax : +2721 - 658 1676 Mobile  : +2

Re: TSM and DB2

We only use the DB2 API to backup our DB2 databases to TSM Kind Regards, Jacques van den Berg TSM / Storage / SAP Basis Administrator Pick 'n Pay IT Email : jvandenb...@pnp.co.za Tel : +2721 - 658 1711 Fax : +2786 - 5134272 Mobile : +2782 - 653 8164 "Living on Earth is

Re: Orphaned DB2 data

Hi, Does your sql select & query occ give the same result? We are running DB2 Ver8 & 9. I delete the backups with db2adutl. This only marks them as inactive in tsm. Tsm expire inventory will the delete them from tsm. Regards, Jacques van den Berg TSM / Storage / SAP Basis Administrator

Re: Orphaned DB2 data

Q occ also tells you the number of files which is the number of backups you have in tsm divided by the number of sessions you use to do your db2 backup. Jacques van den Berg TSM / Storage / SAP Basis Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] Tel : +2721 - 658 171

Re: Different db2 retention periods

This will only work for offline backups otherwise you have to keep 10 years of log files for you oldest backup. My 10 cents... Jacques van den Berg TSM / Storage / SAP Basis Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] Tel : +2721 - 658 1711 Fax : +2721 - 658 1676 M

TSM Disk pools on EMC issue

mes that the EMC path timeout. Has anyone experienced something similar? Regards, Jacques van den Berg TSM / Storage / SAP Basis Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Tel : +2721 - 658 1711 Fax : +2721 - 658 1676 Mobile :

Re: TSM Disk pools on EMC issue

eState Q-IOs Errors == 0 fscsi0hdisk14 SP B0 active dead 0 1 0 fscsi0hdisk15 SP A0 active alive 0 0 Jacques van den Berg TSM / Storage /

Re: TSM Disk pools on EMC issue

Thanks for the info guys. SANDISCOVERY is turned ON at the moment. I have turned it OFF now - just waiting for the go-ahead to reboot the server. Regards, Jacques van den Berg TSM / Storage / SAP Basis Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] Tel : +2721 - 658 171

GUI baclient does not restore all files

suggestions? TSM server 5.4.1 TSM BACLIENT 5.4.1 AIX 5.3 Regards, Jacques van den Berg TSM / Storage / SAP Basis Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Tel : +2721 - 658 1711 Fax : +2721 - 658 1676 Mobile : +2782 - 653 81

Re: IBM TS3310 vs IBM TS3200

filled up and could not migrate to tape. I also found the library (robotic part) quite "slow". Then again I'm used to a 3584. Regards, Jacques van den Berg TSM / Storage / SAP Basis Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] Tel : +2721 - 658 1711 Fax : +27

Re: Error running DB2 backups using TSM

Hi Lori, Look in the file /usr/tivoli/tsm/client/api/bin/sample/dsmrc.h RC 186 means you don't have an archive copy group. #define DSM_RC_TL_NOACG186 /* Archive req, no archive copy group * Regards, Jacques van den Berg TSM / Storage / SAP Basis Administrator Pick 'n Pa