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 expensive
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 : +2782 - 653
,
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 - 653 8164
Dis altyd lente in die hart van die mens wat God
en sy medemens liefhet
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.co.za
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 medemens
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 Pay IT
Email
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 : +2721 - 658 1676
Mobile
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 8164
Dis altyd
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 1711
Fax
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
Mobile
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 : +2782 - 653 8164
Dis altyd lente in die
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 / SAP Basis
Hi,
Does your sql select query occ NODE 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
Pick
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 1711
Fax
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 Vianney
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 : 021 - 658
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 hart van die mens
=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
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 lente
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 - 653 8164
Dis altyd lente
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 : [EMAIL
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 hart van die
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 mens wat
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 : [EMAIL
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 liefhet
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 / SAP Storage
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 : 021 - 658 1699
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 : 021
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
Jacques van den Berg
TSM
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
Dis
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 lente in die
31 matches
Mail list logo