Re: checkout DB2 backup [Virus checked]
Hi Frank , Copy them to the copy storage pool and run move drmedia. Frank Mueller [EMAIL PROTECTED] Sent by: ADSM: Dist Stor To Manager[EMAIL PROTECTED] [EMAIL PROTECTED] cc Subject 19.04.2004 16:14checkout DB2 backup [Virus checked] Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Hi *, we want to check out a DB2-backup. We backup our DB2-DB over the DB2-api in the TSM. The data are stored in a 3494 library. Now we want to move the tapes in a other location (out of the library, for example a safe). What is the best way to move the data out of the library??? Best regards, Frank inline: C6507223.gifinline: graycol.gifinline: pic28145.gifinline: ecblank.gif
retention period
Hi all , I archived some files whith retaintion period 365 days , if i change retention period to 999 , is that will affect files archieved with old retention period. TSM server 4.2 Regards
how to retrieve expired files
Hi all , We have files that have been expired before 4 days , Can i retrieve them if i perform database restore from db backup that is taken before 5 days? The files were residing in non writtable CD before expiration. Any experience ? Best regards.
ANR0102E asalloc.c error mesage at the end of db2 backups
Hi all , have a problem with db2 backups.Last 2 days im receiving ANR0102E asalloc.c(5006): Error 1 inserting row in table AS.Segments. at the end of db2 backups.I can't see them with db2adutl query command but db2 list history command tell me that they are successful. The meaning of ANR0102E is ANR0102E Source file(line number): Error error code inserting row in table table name. Explanation: An internal error has occurred in an attempt to add data to a server database table. This message always accompanies another error message and provides more detail about that error. System Action: The activity that generated this error fails. User Response: Contact your service representative. any experience ? Thanks.
Re: help:db2 backup question!
db2 backups are API backups and you coulnd not see them with admc -id=client -password=client backup * command you can see them with db2adutl or db2 get db history commands fenglimian fenglimian@163. To: [EMAIL PROTECTED] COM cc: Sent by: ADSM: Subject: Re: help:db2 backup question! Dist Stor Manager [EMAIL PROTECTED] T.EDU 08.01.2003 10:01 Please respond to ADSM: Dist Stor Manager MUSTAFA BAYTAR: With db2adutl query I can find the images,and I also can restore the database successly.But why I could not see it with admc -id=client -password=client backup *? === 2003-01-08 09:07:00 try db2adutl query full command at db2 promt? if you can see timesamp for this backup image use db2 restore db db0107 use tsm fenglimian fenglimian@163. To: [EMAIL PROTECTED] COM cc: Sent by: ADSM: Subject: help:db2 backup question! Dist Stor Manager [EMAIL PROTECTED] T.EDU 08.01.2003 07:59 Please respond to ADSM: Dist Stor Manager Hi,all My TSM server is TSM 4.1.2,OS is AIX 4.3.3(44P-170).I'm doing a DB2 backup test now,but I had meeted a very strange problem. The output of backup is : db2 = backup db db0107 use tsm Backup successful. The timestamp for this backup image is : 20030108134803 I used the command q content vol** and can saw this file,but when I tried to restore it,the message was this file not found.and I runned the commandq backup * still not found this file,what problem with me? And at the same time I checked my db2diag.log alse not found any error message about this backup operation. fenglimian [EMAIL PROTECTED] 2003-01-08 = = = = = = = = = = = = = = = = = = = = fenglimian [EMAIL PROTECTED] 2003-01-08
Re: help:db2 backup question!
try db2adutl query full command at db2 promt? if you can see timesamp for this backup image use db2 restore db db0107 use tsm fenglimian fenglimian@163. To: [EMAIL PROTECTED] COM cc: Sent by: ADSM: Subject: help:db2 backup question! Dist Stor Manager [EMAIL PROTECTED] T.EDU 08.01.2003 07:59 Please respond to ADSM: Dist Stor Manager Hi,all My TSM server is TSM 4.1.2,OS is AIX 4.3.3(44P-170).I'm doing a DB2 backup test now,but I had meeted a very strange problem. The output of backup is : db2 = backup db db0107 use tsm Backup successful. The timestamp for this backup image is : 20030108134803 I used the command q content vol** and can saw this file,but when I tried to restore it,the message was this file not found.and I runned the commandq backup * still not found this file,what problem with me? And at the same time I checked my db2diag.log alse not found any error message about this backup operation. fenglimian [EMAIL PROTECTED] 2003-01-08
Re: DB2 backup
Hi Mario , First define DSMI_DIR , DSMI_CONFIG as sistem environment parameters in NT client for example : DSMI_DIR C:\Programfiles\tivoli\tsm\client\api\bin (this is your TSM installition api\bin directory) DSMI_CONFIG C:\Programfiles\tivoli\tsm\client\api\bin\dsm.opt and at db2 command promt isue db2 backup db your_db online use adsm open (session numbers) sessions Mario Behring mariobehring@YA To: [EMAIL PROTECTED] HOO.COM cc: (bcc: MUSTAFA BAYTAR/BILSIS/ANADOLU) Sent by: ADSM: Subject: DB2 b Dist Stor Manager [EMAIL PROTECTED] T.EDU 17.10.2002 00:25 Please respond to ADSM: Dist Stor Manager Gentlemen, Does anyone know or have some reliable configuration steps for DB2 for Windows NT online backup using the TSM client ? My environment is this: = TSM Server 5.1.1.0 running on a Windows 2000 Server machine = TSM Backup-Archive Client 4.1.2.14 running on a Windows NT Server 4.0 SP6a machine with 2GB RAM The regular backup is running fine, but I need to backup the DB2 instances without having to stop them or the DB2 services. Thanks in advance. Mario Behring IT Consultant 55 11 9540-8383 __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com
Re: DB2 +INFORMIX--------TSM
Hi Muthyam , 1.For db2 backups you don't need any special configuration for sys opt files but you must define DSMI_DIR , DSMI_CONFIG and DSMI_LOG parametes in db2 environment profile.For example like this. DSMI_DIR=/usr/tivoli/tsm/client/api/bin DSMI_CONFIG=/usr/tivoli/tsm/client/api/bin/dsm.opt DSMI_LOG=/db2/AGP/adsm_log i have not any experience whith INFORMIX backups. 2. You can take DB2 32 bit instance backup to TSM. 3.I'm using one tape stgpool for all my db2 backups. 4.In my configuration db2 backup inactive logs directly to TSM. Muthyam Reddy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent by: ADSM: cc: (bcc: MUSTAFA BAYTAR/BILSIS/ANADOLU) Dist StorSubject: DB2 +INFORMIXTSM Manager [EMAIL PROTECTED] T.EDU 01.10.2002 16:15 Please respond to ADSM: Dist Stor Manager Good morning, I need help in taking Informix and DB2 backups to TSM from a single node. I have few basic questions like... 1. How to configure sys opt files to accept both backups at a time. 2.Can I take DB2 32 bit instance backup to TSM(documentation shows it should be 64bit). 3.wich way works better for db2 backups to saparate stgpool. 4.How logical log backup works with DB2 . I appriciate if anyone sharers there experience in taking two kind of backups to TSM. thanks and regards mani. + This electronic mail transmission contains information from Joy Mining Machinery which is confidential, and is intended only for the use of the proper addressee. If you are not the intended recipient, please notify us immediately at the return address on this transmission, or by telephone at (724) 779-4500, and delete this message and any attachments from your system. Unauthorized use, copying, disclosing, distributing, or taking any action in reliance on the contents of this transmission is strictly prohibited and may be unlawful. +
Re: (Silly?) DB2 Backup question
Hi Bill, Yes you will be able to restore the database from online backup but before online db restore you must restore db logs that have been active during online backup into log_dir directory and after restore you must rollforward db to end of logs .for successful restore you need only logs than have been active during online backup if you want point in time recovery than you need all logs that you have taken after backup Main difference between online backup restore and offline backup restore is that you dont need logs during offline restore.DB2 specialist recommendet at least one offline backup per week. Bill Boyer bill.boyer@VERI To: [EMAIL PROTECTED] ZON.NET cc: Sent by: ADSM: Subject: Re: (Silly?) DB2 Backup question Dist Stor Manager [EMAIL PROTECTED] T.EDU 20.09.2002 21:18 Please respond to ADSM: Dist Stor Manager There is a redbook, Backing up DB2 Using TSM SG24-6247 that has sample scripts for different full/log backup retention using the DB2ADUTL utility. I have this running using only ONLINE backups plus the DB2 user exit supplied by TSM for transaction log archiving. My biggest question has been if I only take ONLINE backups with the LOGS will I be able to restore the database, or do I need to do occassional OFFLINE backups to be able to recover? I also believe that the ONLINE backup does backup the log records that have occurred during the backup.I remember reading something about this somewhere, but I can't find it again. So I won't say I'm 100% sure about this. I do know that after an ONLINE backup the DB2ADUTL shows me with additional LOG backups, too. Bill Boyer DSS, Inc. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Levinson, Donald A. Sent: Friday, September 20, 2002 1:40 PM To: [EMAIL PROTECTED] Subject: Re: (Silly?) DB2 Backup question Log files are absolutely required if you are performing online backups. A. the database has to be in logretain mode to allow an online backup B. all transactions that occur during an online backup only go to log and won't be captured in the backup AFAIK. Otherwise logfile archiving is only necessary if you are interested in recovering the data that was committed after the last backup, if it is acceptable to lose all the data that is entered between backups then there is no need to archive log files. The practice I use is to perform offline backups every night (my outage window allows this) and log archives whenever a log is released, the log archives have a 30 day retention. Or you could hack together a script to backup the released logs and then delete them after the next successful offline DB2 backup so that TSM marks them as deleted. -Original Message- From: Lars Bebensee [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 2:18 AM To: [EMAIL PROTECTED] Subject: (Silly?) DB2 Backup question Hi guys and girls, this question is one of the general sort, so forgive me if it has been answered here or in some manual I haven't red yet. Probably, I just need a simpler description. AFAIK, there are three ways to backup a database: 1. Offline filesystem backup 2. Offline backup in the databases quiesced mode via some api 3. Online backup via api The first question I have is about the transaction log archiving. With which of the above does it make sense and why? The second one: does it make sense to run offline AND online backups in a backup cylce, or will one of them be save enough? I read through the TSM Redbook on DB2 UDB implementation. It just explains the ways RDBMS backups can be done not which combinations are useful. As far as I could extract, it is rather useless doing offline backups and log file archiving but no online backups, right?? Thanks in advance Lars This transmittal may contain confidential information intended solely for the addressee. If you are not the intended recipient, you are hereby notified that you have received this transmittal in error; any review, dissemination, distribution or copying of this transmittal is strictly prohibited. If you have received this communication in error, please notify us immediately by reply or by telephone (collect at 907-564-1000) and ask to speak with the message sender. In addition, please immediately delete this message and all attachments. Thank you.
Re: Direct archiving of DB2/SAP R3 logs to TSM
Hi Lindy , use db2adutl query logs command to see logs and db2adutl EXTRACT LOGS BETWEEN S0x and S0x to restore them Crawford, Lindy To: [EMAIL PROTECTED] lcrawford@BOECO cc: (bcc: MUSTAFA BAYTAR/BILSIS/ANADOLU) RP.CO.ZASubject: Direct archiving of DB2/SAP R3 logs to TSM Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] T.EDU 12.09.2002 08:50 Please respond to ADSM: Dist Stor Manager Hi TSMers, Please could you assist me. We have set up db2 to archive the logs directly to TSM instead of to a filesystem. The problem I am faced with now is I am not sure how to retrieve these files.do you use TSM or DB2 to retrieve them and where will it put the log files Any ideas. Regards. Lindy Crawford Business Solutions: IT BoE Corporate * +27-31-3642185 ...OLE_Obj... +27-31-3642946 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] WARNING: Any unauthorised use or interception of this email is illegal. If this email is not intended for you, you may not copy, distribute nor disclose the contents to anyone. Save for bona fide company matters, BoE Ltd does not accept any responsibility for the opinions expressed in this email. For further details please see: http://www.boe.co.za/emaildisclaimer.htm
Re: Restoring DB2, SQL and Exchange
Hi Hussein , put NODename7026-B80 name in the RS6000 7046-B50 /usr/tivoli/tsm/client/ba/bin/dsm.sys file. if you can see B80 db2 backups with db2adutl query full command you are ready to restore if you can't execute dsmapipw command enter node name and password and then try db2adutl query full command again. regards Hussein Abdirahman hussein.abdirahman@IR To: [EMAIL PROTECTED] WINTOY.COMcc: (bcc: MUSTAFA BAYTAR/BILSIS/ANADOLU) Sent by: ADSM: Dist Subject: Restoring DB2, SQL and Exchange Stor Manager [EMAIL PROTECTED] 03.09.2002 17:18 Please respond to ADSM: Dist Stor Manager Hi TSMers; Anyone out there has a procedure on restoring those databases to a different systems? My DB2 is on AIX 4.3.3. The DB is currently on a RS6000 7026-B80. I want to restore it on RS6000 7046-B50. Does it matter? SQL and Exchange are on Win2K. your help is appreciated in advance Hussein UNIX Administrator IrwinToy LTD Toronto-Canada
Re: DB2 restore takes long
Hi Lindy , We have SAP R3 4.B with DB2 database running on aix 4.3.3 and we had similar problem about 1.5 years ago. our db2 size was 120 GB and when we started database restore its took nearly 12 hours to create db2 conteiners and 4 hours to restore them. after that we have moved filesystem conteiners to rowdevices conteiners and distrubute them over diferent disks . now our db2 size is 420 GB and restore take approximately 4 hours. Crawford, Lindy To: [EMAIL PROTECTED] lcrawford@BOECO cc: (bcc: MUSTAFA BAYTAR/BILSIS/ANADOLU) RP.CO.ZASubject: DB2 restore takes long Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] T.EDU 15.08.2002 10:26 Please respond to ADSM: Dist Stor Manager Hi TSMers, Could some please assist me. I did a restore yesterday, started it 8:13am and it only completed at 21:04 pm. This for the environment that we work with it is unacceptable in terms of response. My client - node is as follows:_ TSM 4.2 DB2 7.2 SAP R3 4.6c Database size is : 48gigs What can I do to make this process faster. The reason why I am concerned is that my backup only takes 1h30mins, so the most time it took I would have expected it to be 2 or 3hours. Please help!!! Lindy Crawford Business Solutions: IT BoE Corporate * +27-31-3642185 ...OLE_Obj... +27-31-3642946 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] WARNING: Any unauthorised use or interception of this email is illegal. If this email is not intended for you, you may not copy, distribute nor disclose the contents to anyone. Save for bona fide company matters, BoE Ltd does not accept any responsibility for the opinions expressed in this email. For further details please see: http://www.boe.co.za/emaildisclaimer.htm
Re: DB2 restore takes long
Hi Lindy, We do online backups every Weekday and offline backup every Sunday.Every day we are running backup storage pools .All backups have 10 days retention periods.We dont keep monthly or weekly backups but every Monday in our disaster recovery center we are restoring db2 ofline backups from offsite copies. Crawford, Lindy To: [EMAIL PROTECTED] lcrawford@BOECO cc: (bcc: MUSTAFA BAYTAR/BILSIS/ANADOLU) RP.CO.ZASubject: Re: DB2 restore takes long Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] T.EDU 15.08.2002 15:17 Please respond to ADSM: Dist Stor Manager Hi Just as a matter of interest, how does rawdevices containers work??? With your db backups, do you do weekly and monthly backups , daily etc and what type of retention periods do use for these .. Do you also have offsite copies of these backups and how do you do them at present.?? Thanks you your assistance. Lindy Crawford Business Solutions: IT BoE Corporate * +27-31-3642185 +27-31-3642946 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: MUSTAFA BAYTAR [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 10:18 To: [EMAIL PROTECTED] Subject: Re: DB2 restore takes long Hi Lindy , We have SAP R3 4.B with DB2 database running on aix 4.3.3 and we had similar problem about 1.5 years ago. our db2 size was 120 GB and when we started database restore its took nearly 12 hours to create db2 conteiners and 4 hours to restore them. after that we have moved filesystem conteiners to rowdevices conteiners and distrubute them over diferent disks . now our db2 size is 420 GB and restore take approximately 4 hours. Crawford, Lindy To: [EMAIL PROTECTED] lcrawford@BOECO cc: (bcc: MUSTAFA BAYTAR/BILSIS/ANADOLU) RP.CO.ZASubject: DB2 restore takes long Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] T.EDU 15.08.2002 10:26 Please respond to ADSM: Dist Stor Manager Hi TSMers, Could some please assist me. I did a restore yesterday, started it 8:13am and it only completed at 21:04 pm. This for the environment that we work with it is unacceptable in terms of response. My client - node is as follows:_ TSM 4.2 DB2 7.2 SAP R3 4.6c Database size is : 48gigs What can I do to make this process faster. The reason why I am concerned is that my backup only takes 1h30mins, so the most time it took I would have expected it to be 2 or 3hours. Please help!!! Lindy Crawford Business Solutions: IT BoE Corporate * +27-31-3642185 ...OLE_Obj... +27-31-3642946 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] WARNING: Any unauthorised use or interception of this email is illegal. If this email is not intended for you, you may not copy, distribute nor disclose the contents to anyone. Save for bona fide company matters, BoE Ltd does not accept any responsibility for the opinions expressed in this email. For further details please see: http://www.boe.co.za/emaildisclaimer.htm WARNING: Any unauthorised use or interception of this email is illegal. If this email is not intended for you, you may not copy, distribute nor disclose the contents to anyone. Save for bona fide company matters, BoE Ltd does not accept any responsibility for the opinions expressed in this email. For further details please see: http://www.boe.co.za/emaildisclaimer.htm
Re: db2 restore using tsm
Hi Droped db2 database restore may take a long time to create db2 conteiners if they are not at rowdevice increase CommTimeOut parameter to 1 and try again. Crawford, Lindy To: [EMAIL PROTECTED] lcrawford@BOECO cc: (bcc: MUSTAFA BAYTAR/BILSIS/ANADOLU) RP.CO.ZASubject: Re: db2 restore using tsm Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] T.EDU 14.08.2002 08:53 Please respond to ADSM: Dist Stor Manager Hi It is 42 gigs and yes I did drop the database before the restore. Lindy -Original Message- From: MUSTAFA BAYTAR [mailto:[EMAIL PROTECTED]] Sent: 14 August 2002 07:51 To: [EMAIL PROTECTED] Subject: Re: db2 restore using tsm hi how GB is your db2 database size? are you drop the database before restore Crawford, Lindy To: [EMAIL PROTECTED] lcrawford@BOECO cc: (bcc: MUSTAFA BAYTAR/BILSIS/ANADOLU) RP.CO.ZASubject: Re: db2 restore using tsm Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] T.EDU 14.08.2002 08:33 Please respond to ADSM: Dist Stor Manager Hi The CommTimeOut was initially set to 300, when I had the problem I increased it to 600, but still had no joy. Thanks Lindy -Original Message- From: MUSTAFA BAYTAR [mailto:[EMAIL PROTECTED]] Sent: 14 August 2002 07:07 To: [EMAIL PROTECTED] Subject: Re: db2 restore using tsm Hi Lindy , What is your CommTimeOut parameter in dsmserv.opt file Crawford, Lindy To: [EMAIL PROTECTED] lcrawford@BOECO cc: (bcc: MUSTAFA BAYTAR/BILSIS/ANADOLU) RP.CO.ZASubject: db2 restore using tsm Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] T.EDU 13.08.2002 22:59 Please respond to ADSM: Dist Stor Manager Hi TSMers! Urgent..I am having problems restoring a SAP R/3 DB2 database from a backup into tsm. It hangs at sendw for a while and finally bombs out without doing the restore.. PLEASE HELP... Lindy Crawford Business Solutions: IT BoE Corporate * +27-31-3642185 ...OLE_Obj... +27-31-3642946 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] WARNING: Any unauthorised use or interception of this email is illegal. If this email is not intended for you, you may not copy, distribute nor disclose the contents to anyone. Save for bona fide company matters, BoE Ltd does not accept any responsibility for the opinions expressed in this email. For further details please see: http://www.boe.co.za/emaildisclaimer.htm WARNING: Any unauthorised use or interception of this email is illegal. If this email is not intended for you, you may not copy, distribute nor disclose the contents to anyone. Save for bona fide company matters, BoE Ltd does not accept any responsibility for the opinions expressed in this email. For further details please see: http://www.boe.co.za/emaildisclaimer.htm WARNING: Any unauthorised use or interception of this email is illegal. If this email is not intended for you, you may not copy, distribute nor disclose the contents to anyone. Save for bona fide company matters, BoE Ltd does not accept any responsibility for the opinions expressed in this email. For further details please see: http://www.boe.co.za/emaildisclaimer.htm
Re: db2 restore using tsm
Hi Lindy , What is your CommTimeOut parameter in dsmserv.opt file Crawford, Lindy To: [EMAIL PROTECTED] lcrawford@BOECO cc: (bcc: MUSTAFA BAYTAR/BILSIS/ANADOLU) RP.CO.ZASubject: db2 restore using tsm Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] T.EDU 13.08.2002 22:59 Please respond to ADSM: Dist Stor Manager Hi TSMers! Urgent..I am having problems restoring a SAP R/3 DB2 database from a backup into tsm. It hangs at sendw for a while and finally bombs out without doing the restore.. PLEASE HELP... Lindy Crawford Business Solutions: IT BoE Corporate * +27-31-3642185 ...OLE_Obj... +27-31-3642946 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] WARNING: Any unauthorised use or interception of this email is illegal. If this email is not intended for you, you may not copy, distribute nor disclose the contents to anyone. Save for bona fide company matters, BoE Ltd does not accept any responsibility for the opinions expressed in this email. For further details please see: http://www.boe.co.za/emaildisclaimer.htm
Re: db2 restore using tsm
hi how GB is your db2 database size? are you drop the database before restore Crawford, Lindy To: [EMAIL PROTECTED] lcrawford@BOECO cc: (bcc: MUSTAFA BAYTAR/BILSIS/ANADOLU) RP.CO.ZASubject: Re: db2 restore using tsm Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] T.EDU 14.08.2002 08:33 Please respond to ADSM: Dist Stor Manager Hi The CommTimeOut was initially set to 300, when I had the problem I increased it to 600, but still had no joy. Thanks Lindy -Original Message- From: MUSTAFA BAYTAR [mailto:[EMAIL PROTECTED]] Sent: 14 August 2002 07:07 To: [EMAIL PROTECTED] Subject: Re: db2 restore using tsm Hi Lindy , What is your CommTimeOut parameter in dsmserv.opt file Crawford, Lindy To: [EMAIL PROTECTED] lcrawford@BOECO cc: (bcc: MUSTAFA BAYTAR/BILSIS/ANADOLU) RP.CO.ZASubject: db2 restore using tsm Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] T.EDU 13.08.2002 22:59 Please respond to ADSM: Dist Stor Manager Hi TSMers! Urgent..I am having problems restoring a SAP R/3 DB2 database from a backup into tsm. It hangs at sendw for a while and finally bombs out without doing the restore.. PLEASE HELP... Lindy Crawford Business Solutions: IT BoE Corporate * +27-31-3642185 ...OLE_Obj... +27-31-3642946 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] WARNING: Any unauthorised use or interception of this email is illegal. If this email is not intended for you, you may not copy, distribute nor disclose the contents to anyone. Save for bona fide company matters, BoE Ltd does not accept any responsibility for the opinions expressed in this email. For further details please see: http://www.boe.co.za/emaildisclaimer.htm WARNING: Any unauthorised use or interception of this email is illegal. If this email is not intended for you, you may not copy, distribute nor disclose the contents to anyone. Save for bona fide company matters, BoE Ltd does not accept any responsibility for the opinions expressed in this email. For further details please see: http://www.boe.co.za/emaildisclaimer.htm
Re: replacing all 3590 with 3590 extended
Hi Eliza , We have 4 onsite pools and 2 copypools.I have defined our K tapes to all onsite pools as private .J tapes are still scratch. TSM use only K types for onsite operations , copy storage pools operations use only scrach volumes and they all are J tapes. Eliza Lau [EMAIL PROTECTED]To: [EMAIL PROTECTED] .VT.EDU cc: (bcc: MUSTAFA BAYTAR/ATIM/ICECEK) Sent by: Subject: Re: replacing all 3590 with 3590 extended ADSM: Dist Stor Manager [EMAIL PROTECTED] RIST.EDU 12.06.2002 21:49 Please respond to ADSM: Dist Stor Manager Yes, but how? There is only one scratch pool and tapes are allocated from this scratch pool as needed when the primary tapepool is backed up to the offsite tapeback. Is there a way to define 2 scratch pools and allocate primary tapes from the Kscratch pool and offsite from the Jscratch pool? Eliza Hi Eliza, Define K tapes to onsite storage pools and J tapes to offsite pools. Eliza Lau [EMAIL PROTECTED]To: [EMAIL PROTECTED] .VT.EDU cc: (bcc: MUSTAFA BAYTAR/ATIM/ICECEK) Sent by: Subject: replacing all 3590 with 3590 extended ADSM: Dist Stor Manager [EMAIL PROTECTED] RIST.EDU 12.06.2002 17:57 Please respond to ADSM: Dist Stor Manager Hi TSMers, We are looking into replacing 1200 3590 J tapes with 600 3590 extended length K tapes to make room in the 3494. While the state is cutting 9% of the University's budget, it is a tremendous waste to throw away 1200 perfectly fine tapes. Now my boss wants to know if there is a way we can use the J tapes for the offsite storage pool only. I looked throught the Admin Reference and there doesn't seem to be a way to do: backup stgpool tapepool tapeback scratch=no volumenames=file:listof3590 Any suggestions? server: TSM 4.1.3 on AIX 4.3.3 tape library: 3494 Thanks, Eliza Lau Virginia Tech Computing Center 1700 Pratt Drive Blacksburg, VA 24060 [EMAIL PROTECTED]
Re: replacing all 3590 with 3590 extended
Hi Eliza, Define K tapes to onsite storage pools and J tapes to offsite pools. Eliza Lau [EMAIL PROTECTED]To: [EMAIL PROTECTED] .VT.EDU cc: (bcc: MUSTAFA BAYTAR/ATIM/ICECEK) Sent by: Subject: replacing all 3590 with 3590 extended ADSM: Dist Stor Manager [EMAIL PROTECTED] RIST.EDU 12.06.2002 17:57 Please respond to ADSM: Dist Stor Manager Hi TSMers, We are looking into replacing 1200 3590 J tapes with 600 3590 extended length K tapes to make room in the 3494. While the state is cutting 9% of the University's budget, it is a tremendous waste to throw away 1200 perfectly fine tapes. Now my boss wants to know if there is a way we can use the J tapes for the offsite storage pool only. I looked throught the Admin Reference and there doesn't seem to be a way to do: backup stgpool tapepool tapeback scratch=no volumenames=file:listof3590 Any suggestions? server: TSM 4.1.3 on AIX 4.3.3 tape library: 3494 Thanks, Eliza Lau Virginia Tech Computing Center 1700 Pratt Drive Blacksburg, VA 24060 [EMAIL PROTECTED]
Re: More details: Db2 on AIX
Hi Borja , Find where dsmapipw file is located and run it and then try to backup db2 again. Borja Borrego borrego@GMX.To: [EMAIL PROTECTED] DE cc: (bcc: MUSTAFA BAYTAR/ATIM/ICECEK) Sent by: Subject: More details: Db2 on AIX ADSM: Dist Stor Manager [EMAIL PROTECTED] RIST.EDU 12.06.2002 19:23 Please respond to ADSM: Dist Stor Manager Hi all once again! More data related to the Db2 -- TSM problem. I hope this helps. 1.- TSM version: 5.1 S.O. : 4.3.3. y DB2 : 7.01 Host: crtpxd The online backup has worked fine for about 7 days. Then. It has crashed returning the following error. db2 = backup db TJD online use adsm SQL2062N An error occurred while accessing media /db2/db2TJD/sqllib/adsm/libtadsm.a. Reason code: 610. 2.- My dsmclientV3.cat files crtpxd/root:/usr/tivoli/tsm/client/api/bin/en_US ls -al total 616 drwxr-sr-x 2 root sys 512 Jun 11 16:24 . drwxr-sr-x 5 root sys 512 Jun 11 18:27 .. -rwxrwxrwx 1 root sys 304751 Jun 11 16:21 dsmclientV3.cat y ... crtpxd/root:/usr/lib/nls/msg/en_US ls -al dsmclientV3.cat lrwxrwxrwx 1 root system52 Jun 12 11:57 dsmclientV3.cat - /usr/tivoli/tsm/client/api/bin/en_US/dsmclientV3.cat 3.- The last log sent to TSM NODE_NAME: crtpxd_DB2 FILESPACE_NAME: /TJD FILESPACE_ID: 1 TYPE: FILE HL_NAME: /NODE/ LL_NAME: S226.LOG OBJECT_ID: 790688 ARCHIVE_DATE: 2002-06-07 11:26:42.00 OWNER: db2TJD DESCRIPTION: Log file for DB2 database TJD CLASS_NAME: DEFAULT 4.- The last online backup done with TSM NODE_NAME: crtpxd_DB2 FILESPACE_NAME: /TJD FILESPACE_ID: 1 STATE: ACTIVE_VERSION TYPE: FILE HL_NAME: /NODE/ LL_NAME: FULL_BACKUP.20020607015907.1 OBJECT_ID: 788236 BACKUP_DATE: 2002-06-07 02:00:16.00 DEACTIVATE_DATE: OWNER: db2TJD CLASS_NAME: DEFAULT 5.- More: crtpxd/root:/ /usr/lpp/db2_07_01/adsm/db2adutl query full db TJD --- Database directory is empty --- Query for database TJD Retrieving FULL DATABASE BACKUP information. 1 Time: 20020607015907 Oldest log: S222.LOG Node: 0Sessions: 1 [...] 8 Time: 20020530183503 Oldest log: S000.LOG Node: 0Sessions: 1 6.- And more crtpxd/root:/usr/lpp/db2_07_01/adsm ./db2adutl verify full Query for database TJD Retrieving FULL DATABASE BACKUP information. Please wait. FULL DATABASE BACKUP image: ./TJD.0.db2TJD.NODE.CATN.20020607015907.001, Node: 0 Do you wish to verify this image (Y/N)? y == BUFFER 1 == [...] == BUFFER 1823 == WARNING only partial image read, bytes read: 28672 of 4194304 Read 0 bytes, assuming we are at the end of the image Image Verification Complete - successful. 7.- I've tried deinstalling TSM and installig version 4.2 -- Error persists And After upgrading to 5.1. -- Error persists 8.- Environment variables for root crtpxd/root:/ env| grep DSMI DSMI_CONFIG=/usr/tivoli/tsm/client/api/bin/dsm.opt DSMI_LOG=/usr/tivoli/tsm/client/api/bin DSMI_DIR=/usr/tivoli/tsm/client/api/bin 9.- Environment variables for db2TJD (db administrador) crtpxd/root:/ su - db2TJD crtpxd:db2TJD 1 env| grep DSMI DSMI_DIR=/usr/tivoli/tsm/client/api/bin DSMI_LOG=/usr/tivoli/tsm/client/api/bin DSMI_CONFIG=/usr/tivoli/tsm/client/api/bin/dsm.opt I hope this helps. Un saludo / Best regards, Borja Borrego Caro ERP IT Systems Division mailto: [EMAIL PROTECTED] Cromion IT - Outsourcing Services for Business Parque Tecnolsgico de Zamudio - Edificio 101 D 48170 ZAMUDIO - SPAIN Office: (+34) 94 601 9485 Fax: (+34) 94 601 9731 Dear all! Our db2 v7.1 online backups on AIX have been working succesfully for 7 days, but now, we get the following error: db2 = backup db swp online use adsm SQL2062N An error occurred while accessing media /db2/db2tjd/sqllib/adsm/libtadsm.a. Reason code: 610. The problem doesn't seem to be due to unavailabilty of the dsmclientV3.cat file (everythig had worked fine for seven days, and the specified linked file exist). Following, the explanation of this API error message + Explanation: The system is unable to open the message txt file (dscameng.txt or dsmclientV3.cat for AIX). On the AS/400 platform this file is QANSAPI/QAANSAMENG(TXT). System Action: The system returns to the calling procedure. User Response: Verify that the dscameng.txt file is in the directory pointed to by DSMI_DIR. For AIX, verify that the dsmclientV3.cat file has a symbolic link /usr/lib/nls/msg/locale
problem with starting dsmserv --Server operation terminated.
Hi all, i receive this mesage after TSM server shutdown running on AIX machine. Any help? ANR0900I Processing options file dsmserv.opt. ANR0990I Server restart-recovery in progress. ANR0200I Recovery log assigned capacity is 600 megabytes. ANR0201I Database assigned capacity is 1000 megabytes. ANR0306I Recovery log volume mount in progress. ANR0353I Recovery log analysis pass in progress. ANR0354I Recovery log redo pass in progress. ANR0355I Recovery log undo pass in progress. ANRD logread.c(233): ThreadId0 Log record at LSN 37615.251.3788 has invalid magic number. ANRD pkthread.c(539): ThreadId0 Run-time assertion failed: owner == LOGOWNER_DB, Thread 0, File dblog.c, Line 1150. ANR7838S Server operation terminated. ANR7837S Internal error DBLOG078 detected. 0x10008214 pkLogicAbort 0x100B5470 DbReadLogRecord 0x1035E2F8 RestartUndo 0x1035F2CC DbRestartRecovery 0x100C0DA4 dbInit 0x103A85A4 admStartServer 0x10001A24 main ANR7833S Server thread 1 terminated in response to program abort. ANR7833S Server thread 2 terminated in response to program abort. ANR7833S Server thread 3 terminated in response to program abort. ANR7833S Server thread 4 terminated in response to program abort. ANR7833S Server thread 5 terminated in response to program abort. ANR7833S Server thread 6 terminated in response to program abort. ANR7833S Server thread 7 terminated in response to program abort. ANR7833S Server thread 8 terminated in response to program abort. ANR7833S Server thread 9 terminated in response to program abort. ANR7833S Server thread 10 terminated in response to program abort. IOT/Abort trap
3494 library with J and K type cartridges
Hi TSM'ers , i have 3494 library with 3590 J and K type cartridges in it for all sequential access storage pool, want to define sequential access storage pool that can use only J type cartridges. Any ideas? Thanks
Re: backup fails because inspection process takes too long.
Hi John, increase CommTimeOut parameter John C Dury [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: (bcc: MUSTAFA BAYTAR/ATIM/ICECEK) Sent by: Subject: backup fails because inspection process takes too long. ADSM: Dist Stor Manager [EMAIL PROTECTED] IST.EDU 12.03.2002 17:30 Please respond to ADSM: Dist Stor Manager We have an AIX client that has an extremely large number of files that is taking a very long time to go through the inspection process and then fails backing up because the TSM client is spending all the time allotted, inspecting and never has enough time to backup the actual files. We've talked to level 2 and they said something about a new feature (no ide what version it will be in) that will have some sort of monitoring capability so it will know what files have changed during the day, and then only back those up at night instead of checking every file and every directory. Anyone know anything about this or have any suggestions on how to get this AIX client to successfully backup instead of spending so much time checking each file? Any help would be greatly appreciated. Thanks, John
Re: How to use string operators in select statement - TSM.
or this select substr(MESSAGE,1,9) from actlog where substr(MESSAGE,1,9)='ANR2565I' mobeenm mobeenm@MICRO To: [EMAIL PROTECTED] N.COM cc: (bcc: MUSTAFA BAYTAR/ATIM/ICECEK) Sent by: Subject: Re: How to use string operators in select statement - TSM. ADSM: Dist Stor Manager [EMAIL PROTECTED] IST.EDU 28.02.2002 11:21 Please respond to ADSM: Dist Stor Manager Sree Kumar, Its absolutely possiblem to do that. Try the following select * from actlog where message like 'ANR2565I%' I think this should do the trick. Hope the climate in Bangalore is good :-) Regards Mobeen Mobeen Mahamood C.M Systems Manager Lead Micron Semiconductor Asia Singapore -Original Message- From: Pothula S Paparao [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 5:15 PM To: [EMAIL PROTECTED] Subject: How to use string operators in select statement - TSM. Hi TSM'ers The below is the message from select output (select * from actlog) All I want to know is whether or not possible to caputue only the message no (ex. ANR2565I) using select query. I tried using string operations in select command. didnt help much. If any select expert tried this pls let me know. Im very much intrested to know about it. Thanks in advance. DATE_TIME: 2001-12-30 00:00:02.00 MSGNO: 2565 SEVERITY: I MESSAGE: ANR2565I 0 schedules for immediate client actions have been deleted. Regards Sreekumar. SO IBM Singapore. Phone : 65-8402634
Re: How to use string operators in select statement - TSM.
Hi , try this select substr(MESSAGE,1,9) from actlog Pothula S Paparao To: [EMAIL PROTECTED] [EMAIL PROTECTED] cc: (bcc: MUSTAFA BAYTAR/ATIM/ICECEK) BM.COM Subject: How to use string operators in select statement - TSM. Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] IST.EDU 28.03.2002 11:15 Please respond to ADSM: Dist Stor Manager Hi TSM'ers The below is the message from select output (select * from actlog) All I want to know is whether or not possible to caputue only the message no (ex. ANR2565I) using select query. I tried using string operations in select command. didnt help much. If any select expert tried this pls let me know. Im very much intrested to know about it. Thanks in advance. DATE_TIME: 2001-12-30 00:00:02.00 MSGNO: 2565 SEVERITY: I MESSAGE: ANR2565I 0 schedules for immediate client actions have been deleted. Regards Sreekumar. SO IBM Singapore. Phone : 65-8402634
Re: UDB restore from a backup made on different AIX-client
put NODename = clientname into client dsm.sys file in the client node where you want to restore the udb Vijay Havaralu vhavaralu@CHU To: [EMAIL PROTECTED] BB.COM cc: (bcc: MUSTAFA BAYTAR/ATIM/ICECEK) Sent by: Subject: UDB restore from a backup made on different AIX-client ADSM: Dist Stor Manager [EMAIL PROTECTED] IST.EDU 15.02.2002 21:51 Please respond to ADSM: Dist Stor Manager Hello, all. We have a problem in restoring the udb restore to an aix-tsm-client node. The backup is previously taken on a different aix-client. Both with the same version 4.1.2.0 tsm-server version is 4.2.1.9. (for example from aix102 db-backup to aix401 db-restore). We tried the options of setting dsm/dsmi dir/config variables, and 'set access a/b * * *'. We tried the method of changing adsm-node name (password) on adsm-server temporarily. On both the methods, db2adutil list commands, (and nomal client restore across nodes), worked fine. But udb-restores always failed across nodes (but works on the same node). Some of the db2adutl and restore outputs are as shown below. I appreciate if any body has a detailed steps or method/s for a successful restore. == ** udb1 redxmsg Retrieving full database backup information. full database backup image: 1, Time: 20020212095531 Oldest log: S000.LOG, Node: 0, Sessions used: 1 full database backup image: 2, Time: 20020212090457 Oldest log: S000.LOG, Node: 0, Sessions used: 1 ** dbaudb@chbsp101e:/u/dbaudb/ADSM == db2 restore db REDXMSGB use adsm taken at 20020212095531 into REDXMSGB replace existing SQL2542N No match for a database image file was found based on the source database alias and timestamp provided. dbaudb@chbsp101e:/u/dbaudb/ADSM ==
Re: Can you explain: Maxnump and keepmp
Keep Mount Point Select whether the node should retain the tape mount point for the entire session. Yes Specifies that the node must retain the tape mount point during the entire session. No Specifies that the node will release the tape mount point if policy definitions cause data to be stored in a disk storage pool after storing data in a sequential storage pool. The default is No. Maximum Mount Points Allowed Enter a number from 0 to 999 to specify the maximum allowed resource usage by this node. A value of 0 specifies that tape drives cannot be acquired for storage operations. Data storage operations must be contained within a disk storage pool and server operations like migration will manage putting data on tape. A value of 0 does not prevent a retrieve operation from acquiring a tape drive. A node is always allowed to acquire at least 1 tape mount point for the purpose of data retrieval. Entering a value other than 0, limits the node to the specified number of tape drives and prevents the node from monopolizing all of the available tape drives. This parameter is optional Robert Ouzen [EMAIL PROTECTED] To: [EMAIL PROTECTED] IFA.AC.IL cc: (bcc: MUSTAFA BAYTAR/ATIM/ICECEK) Sent by: ADSM: Subject: Can you explain: Maxnump and keepmp Dist Stor Manager [EMAIL PROTECTED] ST.EDU 14.02.2002 08:45 Please respond to ADSM: Dist Stor Manager Hi Can anyone explain to me very slowly what the parameters: MAXNUMMP and KEEPMP means when I define a new NODE. The default is for MAXNUMMP 1 and for KEEPMP no I backup first to disk and during the day migrate to tape, just my database (Sap, Exchange ?) I backup directly to tape. Did those parameters can affect performance ?.. I made a little test trying to backup a same node (large client novell 5) once to disk and once to tape. I got a very big difference on performance , to tape took a very long time. Any suggestions will be appreciate. Regards Robert Ouzen [EMAIL PROTECTED]
Re: Need a select command
Robert try this. /* how much data in the pools */ select node_name,backup_mb,backup_copy_mb,archive_mb,archive_copy_mb from auditocc Robert Ouzen [EMAIL PROTECTED] To: [EMAIL PROTECTED] IFA.AC.IL cc: (bcc: MUSTAFA BAYTAR/ATIM/ICECEK) Sent by: ADSM: Subject: Need a select command Dist Stor Manager [EMAIL PROTECTED] ST.EDU 14.02.2002 10:39 Please respond to ADSM: Dist Stor Manager Hi To select guru I need one for calculate the amount of data store in my site. I run q auditocc but I need the total of each domain. T.I.A Robert Ouzen [EMAIL PROTECTED]
590 high performance and 3590 extended high performance cartridges
Hello , Can i use both 3590 high performance and 3590 extended high performance cartridges in 3494 library with two 3590E1A and two 3590E1A extended tape drives. Any experience ? thanks
problem with 3494 library after TSM upgrade from 3.7.4 to 4..2.1.7
Hi everybody! 3494 Library with four 3590 tape drives dont want to mount volumes after TSM upgrade runnig on aix 4.3.3 from 3.7.4 to 4.2.1.7 Error mesage from tsm console is : ANR8304E Time out error on drive 3494DRV11 (/dev/rmt0) in library 3494LIB1. ANR8472I Error reading label of volume in drive 3494DRV11 (/dev/rmt0) of library 3494LIB1. ANR8311E An I/O error occurred while accessing drive 3494DRV11 (/dev/rmt0) for OFFL operation, errno = 22. failed. ANR8310E An I/O error occurred while accessing library 3494LIB1. any help would be great!
Re: Password Expiration
Hi Kelil , Set password expiration period for node administrator to 0.A value of 0 means that Password never expwries. kelil kenzu kelilkenzu@HOTo: [EMAIL PROTECTED] TMAIL.COMcc: (bcc: MUSTAFA BAYTAR/ATIM/ICECEK) Sent by: Subject: Password Expiration "ADSM: Dist Stor Manager" [EMAIL PROTECTED] IST.EDU 21.08.2001 21:50 Please respond to "ADSM: Dist Stor Manager" HI, We are running TSM 3.7.4 on an AIX 4.3.3 Server. Recently we upgraded the NT clients from 3.1.7 to 4.1.3. After the upgrademost of the clients were unable to log into the server. We kept on getting password expiration problem. As a result, we reset the passwords for all nodes that expired. However, the passwords work for a while and they expire. Any Ideas ? Kelil Get your FREE download of MSN Explorer at http://explorer.msn.com
Re: tape drive unavailable WHEN THEY ARE!!!!!
check that all your tape drives are online Joel Fuhrman [EMAIL PROTECTED]To: [EMAIL PROTECTED] NGTON.EDU cc: (bcc: MUSTAFA BAYTAR/ATIM/ICECEK) Sent by: ADSM: Subject: Re: tape drive unavailable WHEN THEY ARE! Dist Stor Manager [EMAIL PROTECTED] T.EDU 15.08.2001 21:48 Please respond to ADSM: Dist Stor Manager Maybe its a false error. Do you have enough tapes available to the tape pool? Do a query stgPoolName f=d and look for Maximum Scratch Volumes Allowed: and see how that compares to the number of tapes in use. Also try a query drive to make sure all the drives are available and defined to the correct devtype. On Tue, 14 Aug 2001, Joe Faracchio wrote: Just moved my 1200 user production system to a new system and I've gotta solve this before my diskpool fills up completely!! I'm having a whole lot of problems with tape mounts and was wondering if anyone can summarize the known problems fixes for this. (what combination of devices.rte and TSM work without problems) I'm on AIX 4.3.3 with TSM 4.1.3. Its a 3466 NSM I've got a 3494 with two 3590s. In a nutshell: I can do a: backup stg diskpool copypool with NO PROBLEMS. But if I do: upd stg diskpool hi=1 low=0 migproc=2 I get : ANR8447E No drives are currently available in library 3494LIB. ANR1401W Mount request denied for volume 200332 - mount failed. I've also seen this with onsite and offsite reclamations. any help would be much appreciated. thanks joe.f. Joseph A Faracchio, Systems Programmer, UC Berkeley Private mail on any topic should be directed to : [EMAIL PROTECTED]
cann't start adsm serv---Urgent
Hi TSM'ers wneh im traying to start TSM server it stops at the Recovery log volume mount in progress and cannot continue. that happened after EMC Fibre Channel interface driver installation. [tivolisrv@root]/usr/tivoli/tsm/server/bindsmserv ANR7800I DSMSERV generated at 23:08:28 on Apr 22 2000. Tivoli Storage Manager for AIX-RS/6000 Version 3, Release 7, Level 3.0 Licensed Materials - Property of IBM 5697-TSM (C) Copyright IBM Corporation 1999. All rights reserved. U.S. Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corporation. ANR0900I Processing options file dsmserv.opt. ANR0990I Server restart-recovery in progress. ANR0200I Recovery log assigned capacity is 600 megabytes. ANR0201I Database assigned capacity is 1000 megabytes. ANR0306I Recovery log volume mount in progress. any ideas
Re: cann't start adsm serv---Urgent
Yes , after upgrade to ver 3.7.4 dsmserv started successfuly.Thanks to all for help. Thomas Gaines tgaines@WESTPTo: [EMAIL PROTECTED] AC.COM.AUcc: (bcc: MUSTAFA BAYTAR/ATIM/ICECEK) Sent by: Subject: Re: cann't start adsm serv---Urgent ADSM: Dist Stor Manager [EMAIL PROTECTED] IST.EDU 14.08.2001 13:14 Please respond to ADSM: Dist Stor Manager Mustafa, I encountered the same problem after installing drivers for ATM NIC's on TSM v3.7.3; NT. I didn't want to restore the database, since the last one that had run had failed. Since it was unlikely support would address it until it was the latest fix level, I installed v.3.7.4 patch. The server started up fine after this. Cheers, Thomas. MUSTAFA BAYTAR [EMAIL PROTECTED] on 08/14/2001 07:31:00 PM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc:(bcc: Thomas Gaines/TO/SYD/IIBG) Subject: cann't start adsm serv---Urgent Hi TSM'ers wneh im traying to start TSM server it stops at the Recovery log volume mount in progress and cannot continue. that happened after EMC Fibre Channel interface driver installation. [tivolisrv@root]/usr/tivoli/tsm/server/bindsmserv ANR7800I DSMSERV generated at 23:08:28 on Apr 22 2000. Tivoli Storage Manager for AIX-RS/6000 Version 3, Release 7, Level 3.0 Licensed Materials - Property of IBM 5697-TSM (C) Copyright IBM Corporation 1999. All rights reserved. U.S. Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corporation. ANR0900I Processing options file dsmserv.opt. ANR0990I Server restart-recovery in progress. ANR0200I Recovery log assigned capacity is 600 megabytes. ANR0201I Database assigned capacity is 1000 megabytes. ANR0306I Recovery log volume mount in progress. any ideas
Re: rename node
Simply rename the node name. You can use command RENAME NODE oldnode_name newnode_name Debbie Lane Debbie.Lane@INTTo: [EMAIL PROTECTED] ERMEC.COM cc: Sent by: ADSM: Subject: rename node Dist Stor Manager [EMAIL PROTECTED] T.EDU 06.08.2001 19:27 Please respond to ADSM: Dist Stor Manager An HP Systems Admin. changed the hostname of an ADSM client. We are at ADSM Server 3.1.2.90 and ADSM client 3.1.0.8. Does ADSM use the first hostname in the /etc/hosts file? There are a few aliases for this hostname in the hosts file. What changes do I need to make to ADSM to have backups run under the new name? Can I move previous backups that were ran as nodeA to nodenewname? Please reply to [EMAIL PROTECTED] as I receive the digest version. Thanks and regards, Debbie
Re: restoring db2 database on other node using TSM.
When we need to restore db2 backup to other node , i'm addinq node = name of the node where db2 backup is taken to the ..api/bin/dsm.opt file in target node.after that you can restore all old node db2 backups from ADSM to target node . Pothula S Paparao To: [EMAIL PROTECTED] 9pothula@SG.cc: (bcc: MUSTAFA BAYTAR/ATIM/ICECEK) IBM.COM Subject: restoring db2 database on other node using TSM. Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] RIST.EDU 06.07.2001 06:28 Please respond to ADSM: Dist Stor Manager hi all, we are backing up database using TSM . We would like to test DB2 database restore using ADSM on other node to avoid future restoration problems. I tried restoring File system from ADSM library to other node using -virtualnodename=nodename. Is there any option like, to recover db2 database in other node. Thanks in advance. regards sree.
Re: TDP for SAP/R3 with DB2
Dear Manoel Braz , Yes you can do backup of SAP R/3 with DB2 without the TDP , but can you explain what you mean in backup not contains configurations of SAP R/3. Manoel Braz manoelbraz@HOTo: [EMAIL PROTECTED] TMAIL.COMcc: (bcc: MUSTAFA BAYTAR/ATIM/ICECEK) Sent by: Subject: TDP for SAP/R3 with DB2 ADSM: Dist Stor Manager [EMAIL PROTECTED] IST.EDU 02.07.2000 15:41 Please respond to ADSM: Dist Stor Manager Hi *SM, Can I do backup of a system SAP R/3 with DB2 without using the TDP? I have the information about backup of SAP R/3 that when I do SAP's backup without TDP, this backup not contains configurations of SAP R/3. Is it true? Thanks.
Re: AIX BA Client Backup Problem
Hi Kelly , DB2 logs all changes to the database in log records.Your DB2 logging them into /db2logs/NODE/ path.. and probably S0007932.LOG is active during backup. I dont't know which logging you are using but if you using circular logging you don't need to backup these logs. if you are using archive logging , when a log file is filled with records ,the log file is copied to directory log_archive by the db2 logging user exit. Once all changed pages referenced in the online active log files have been witten to disks , the online active log file is deleted.The copied log fie in the log_archive directory is now offline active.When directory log_archive fills with offline logs you must archive them using DB2 control center or another tool. I think simply put /db2logs/NODE/ into your exclude list and escape from this situation. Kelly J. LippTo: [EMAIL PROTECTED] lipp@STORSOLcc: (bcc: MUSTAFA BAYTAR/ATIM/ICECEK) .COMSubject: AIX BA Client Backup Problem Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] RIST.EDU 27.06.2001 21:46 Please respond to lipp Client: AIX 4.3.3 TSM Client 4.1.2.0, Server Windows NT 4.1.2.x While attempting to backup a directory either ad-hoc or scheduled, the following results: I'm thinking resource problem but don't know which one. Also, behavior on this client changed after adding a DB2 backup using the API. Ideas? TIA. Dsmerror.log entry: 06/27/01 09:38:52 File '/db2logs/NODE/S0007932.LOG' truncated while reading in Shared Static mode. 06/27/01 09:39:42 File changing during operation 06/27/01 09:39:42 File changing during operation 06/27/01 09:46:02 TcpFlush: Error 32 sending data on Tcp/Ip socket 8. 06/27/01 09:46:02 sessFlushVerb: Error from buffer flush, rc: -50 06/27/01 09:46:02 TcpFlush: Error 32 sending data on Tcp/Ip socket 8. 06/27/01 09:46:03 mpDestroy: Memory Pool #33 doesn't exist 06/27/01 09:47:24 B/A Txn Producer thread, fatal error, signal 6 06/27/01 09:47:24 0xD0014C44 pthread_kill 06/27/01 09:47:24 0xD0014110 _p_raise 06/27/01 09:47:24 0xD0175110 raise 06/27/01 09:47:24 0xD016E864 abort 06/27/01 09:47:24 0xD020B750 __assert 06/27/01 09:47:24 0x10029F0C *UNKNOWN* 06/27/01 09:47:24 0x100DA2CC *UNKNOWN* 06/27/01 09:47:24 0x100D9A0C *UNKNOWN* 06/27/01 09:47:24 0x100D1454 *UNKNOWN* 06/27/01 09:47:24 0x100D0C9C *UNKNOWN* 06/27/01 09:47:24 0x100AA454 *UNKNOWN* 06/27/01 09:47:24 0x100AA2EC *UNKNOWN* 06/27/01 09:47:24 0x100A9E50 *UNKNOWN* 06/27/01 09:47:24 0x100988AC *UNKNOWN* 06/27/01 09:47:24 0x100988FC *UNKNOWN* 06/27/01 09:47:24 0xD00081FC _pthread_body 06/27/01 09:52:21 B/A Txn Producer thread, fatal error, signal 6 06/27/01 09:52:21 0xD0014C44 pthread_kill 06/27/01 09:52:21 0xD0014110 _p_raise 06/27/01 09:52:21 0xD0175110 raise 06/27/01 09:52:21 0xD016E864 abort 06/27/01 09:52:21 0xD020B750 __assert 06/27/01 09:52:21 0x10029F0C *UNKNOWN* 06/27/01 09:52:21 0x100DA2CC *UNKNOWN* 06/27/01 09:52:21 0x100D9A0C *UNKNOWN* 06/27/01 09:52:21 0x100D1454 *UNKNOWN* 06/27/01 09:52:21 0x100D0C9C *UNKNOWN* 06/27/01 09:52:21 0x100AA454 *UNKNOWN* 06/27/01 09:52:21 0x100AA2EC *UNKNOWN* 06/27/01 09:52:21 0x100A9E50 *UNKNOWN* 06/27/01 09:52:21 0x100988AC *UNKNOWN* 06/27/01 09:52:21 0x100988FC *UNKNOWN* 06/27/01 09:52:21 0xD00081FC _pthread_body 06/27/01 10:14:10 B/A Txn Producer thread, fatal error, signal 6 06/27/01 10:14:10 0xD0014C44 pthread_kill 06/27/01 10:14:10 0xD0014110 _p_raise 06/27/01 10:14:10 0xD0175110 raise 06/27/01 10:14:10 0xD016E864 abort 06/27/01 10:14:10 0xD020B750 __assert 06/27/01 10:14:10 0x10029F0C *UNKNOWN* 06/27/01 10:14:10 0x100DA2CC *UNKNOWN* 06/27/01 10:14:10 0x100D9A0C *UNKNOWN* 06/27/01 10:14:10 0x100D1454 *UNKNOWN* 06/27/01 10:14:10 0x100D0C9C *UNKNOWN* 06/27/01 10:14:10 0x100AA454 *UNKNOWN* 06/27/01 10:14:10 0x100AA2EC *UNKNOWN* 06/27/01 10:14:10 0x100A9E50 *UNKNOWN* 06/27/01 10:14:10 0x100988AC *UNKNOWN* 06/27/01 10:14:10 0x100988FC *UNKNOWN* 06/27/01 10:14:10 0xD00081FC _pthread_body From the AIX Prompt: ormal File-- 4,295 /etc/security/lastlog [Sent] Successful incremental backup of '/' ANS1898I * Processed 5,000 files * ANS1898I * Processed15,000 files * ANS1898I * Processed21,500 files * ANS1898I * Processed28,000 files * ANS1898I * Processed37,000 files * ANS1898I * Processed45,500 files * 13.68 MB [- ]The assert subroutine failed: poolP-incSize 0, file mempool.cpp, line 719 IOT/Abort
Re: Error on test TSM-server
are your dsmc sched is runing. if run kill it and start it again. Viirel Veli (Samlink) To: [EMAIL PROTECTED] veli.viirela@Scc: (bcc: MUSTAFA BAYTAR/ATIM/ICECEK) AMLINK.FI Subject: Error on test TSM-server Sent by: "ADSM: Dist Stor Manager" [EMAIL PROTECTED] ST.EDU 28.06.2001 15:53 Please respond to "ADSM: Dist Stor Manager" Any help is greatly appreciated. Following error on TSM client: On client Error.log: 06/25/2001 17:45:38 TcpRead(): recv(): errno = 10054 06/25/2001 17:45:38 sessRecvVerb: Error -50 from call to 'readRtn'. 06/25/2001 17:45:38 RecvSchedPing: Received rc: -50 from sessRecvVerb 06/25/2001 17:45:38 sessInit: Starting communications initialization 06/25/2001 17:45:38 sessInit: Transitioning: sInit state === sTRANSERR state No error on server log. When next scheduled backup is supposed to occur results error on server log: ANR2716E Schedule prompter was not able to contact client NAME using type 1 (111.22.33.44 1501). Server: OS/390 V2R8TSM 4.1.2.0 Client: Windows 2000 MS SQL Server 2000 TSM 4.1.2.12TDP for MS SQL Server 2.2 Sincerely Veli Viirel e-mail: [EMAIL PROTECTED] Oy Samlink Ab phone: +358-9-133 6746 PL 140 fax:+358-9-520 170 02631 ESPOOmobile: +358-40-715 5361 FINLAND http://www.samlink.fi
Re: SQL2025N An I/O error -50 occurred on media ADSM.
The problem is probably related to your TCP/IP configuration. Attempt to 'ping' your ADSM server as soon as the error occurs. In addition, use 'query opt' to check the following settings on your ADSM server: 1. COMMTIMEOUT is on 60 (sec.) by default; increase to 900. 2. IDLETIMEOUT is on 15 (min.) by default. Parameter COMMTIMEOUT is reset by the following ADSM command: adsm setopt COMMTIMEOUT new value Pothula S Paparao To: [EMAIL PROTECTED] 9pothula@SG.cc: (bcc: MUSTAFA BAYTAR/ATIM/ICECEK) IBM.COM Subject: SQL2025N An I/O error -50 occurred on media ADSM. Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] RIST.EDU 23.06.2001 10:43 Please respond to ADSM: Dist Stor Manager hi all, we are often coming across this error while taking online backup from db2-server. this job is run from crontab at 00:00 hours. i m unable to trace out the problem , what causing database backup to fail. do any one knows about it. please reply immdly. Performing database backup type ONLINE issuing db2 backup database tcimain ONLINE USE ADSM WITHOUT PROMPTING 06-15-2001 02:02:05 BACKUP DATABASE tcimain ONLINE USE ADSM WITHOUT PROMPTING 06-15-2001 02:13:39 SQL2025N An I/O error -50 occurred on media ADSM. 06/15/01 02:13:39 Backup tcimain ONLINE USE ADSM WITHOUT PROMPTING sqlcode = -2025 #+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+# ADSM Backup End Time: 02:13:39 AM with rc= -2025
Re: is there a difference?
Lee , if you use exclude /tmp/ TSM will backup all the files that reside in tmp filespace including subdirectories if you use exclude /tmp/* willn't backup files in tmp but will backup files in subdirectories if you use exclude /tmp/.../* no files and subdir's will have backuped Lee, Lin-Yen To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: (bcc: MUSTAFA BAYTAR/ATIM/ICECEK) Subject: is there a difference? Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] RIST.EDU 22.06.2001 00:13 Please respond to ADSM: Dist Stor Manager Hello to all. I am a new user. for Unix client, is there any difference in creating an option exclude /tmp/ vs. exclude /tmp/* Lin-yen Lee S C Johnsons
Re: Reuse of DB backup volumes
if your SAP R/3 database is db2 you can use db2adutl tool for deactivating db backups. Praveen Kumar pavikumar@HOTo: [EMAIL PROTECTED] TMAIL.COM cc: (bcc: MUSTAFA BAYTAR/ATIM/ICECEK) Sent by: Subject: Reuse of DB backup volumes ADSM: Dist Stor Manager [EMAIL PROTECTED] RIST.EDU 19.06.2001 14:04 Please respond to ADSM: Dist Stor Manager Hi all, I am using TSM 4.1 and TDP for SAP R/3. We are taking daily online backup(Monday, Tuesday, Wednesday, Thursday, Friday and Saturday) and weekly offline backup (Sunday). We have 6 sets of online/daily backup and 4 sets of offline/weekly backup. After every days backup we take TSM DB backup and VOLHISTORY and DEVCONFIG backup. Now to reuse the tapes used for TSM DB backup we have to issue the command DELETE VOLhistory with option TYPE=DBBACKUP and TODATE=mm/dd/. But this command deletes all DBbackup info prior to date mm/dd/. I want to delete volhistory info only for one perticuler day. Can anyone guide me how to do this? Because on every online backup day (say Monday), if i delete volhistory info for last Monday, it deletes volhistory info for last Sunday/offline backup as well. Where as i want to retain offline backup volhistory info for one month. Please guide me how to delete DB backup volhistory info only for one perticuler day, so that i can retain volhistory info prior to that day as well. All suggestions are most welcome. Regards Praveen Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Re: Can't kill ./dsmserv
try with command : kill -9 PID Long Nguyen adsm_lm@HOTMTo: [EMAIL PROTECTED] AIL.COM cc: (bcc: MUSTAFA BAYTAR/ATIM/ICECEK) Sent by: Subject: Can't kill ./dsmserv ADSM: Dist Stor Manager [EMAIL PROTECTED] RIST.EDU 14.06.2001 22:07 Please respond to ADSM: Dist Stor Manager When trying to kill the ./dsmserv, I can't kill it. I still see it running with a ps command. Any ideas?? _ Get your FREE download of MSN Explorer at http://explorer.msn.com
Re: TSM 4.1 / TDS / UDB
We are using TSM 3.7 , TDS 2.1 , TSM Loader 4.2 and UDB 5.2 . TSM Loader and UDB are at same NT machine.I have had similiar problem during implementation. on NT machine I defined user TDS who have sysadm and syscontrol prliviliges.After that i created database and tds tables with user TDS. During DB2 ODBC setup i entered this user for user id and password required to access DB2 database. After that problem was resolved. Peter Thomas thomaspj@HOMTo: [EMAIL PROTECTED] E.COM cc: (bcc: MUSTAFA BAYTAR/ATIM/ICECEK) Sent by: Subject: TSM 4.1 / TDS / UDB ADSM: Dist Stor Manager [EMAIL PROTECTED] RIST.EDU 12.06.2001 03:18 Please respond to ADSM: Dist Stor Manager A colleague is working on implementing the TDS / TSM integration. We're using TSM 4.1, TDS Core 2.1.1, TSM Data Loader 4.2 and UDB 6.1 (on AIX). Any attempts to connect from the TSM Data Loader on NT to the AIX UDB database is failing; we can however show that the ODBC connection IS working (likewise, the ODBC connection to TSM 4.1 IS working). Are there any guru's out there who have got this combination working and would be willing to exchange a few eMails??? Thanks Peter Thomas
Re: Restores using 3590
our restore rate for db2 backup from a 3494 library using 3590E over SP switch is 15MB/s , Dearman, Richard To: [EMAIL PROTECTED] rdearm1@UIC.cc: (bcc: MUSTAFA BAYTAR/ATIM/ICECEK) EDU Subject: Restores using 3590 Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] RIST.EDU 01/06/01 23:15 Please respond to ADSM: Dist Stor Manager I'm trying to generate statistics on restoring from a 3494 library using 3590E tape drives. I haven't been able to get a restore rate of more than 1MB/s. Is anyone out there doing restores faster than that coming from tape using a 3590 tape drive. Thanks ***EMAIL DISCLAIMER** This e-mail and any files transmitted with it may be confidential and are intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient or the individual responsible for delivering the e-mail to the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is strictly prohibited. If you have received this e-mail in error, please delete it and notify the sender or contact Health Information Management (312) 996-3941.
Re: 3590 K-Cartridges on TSM 3.7.x
We are using 3590 cartidges on TSM 3.7.3 with 3494 tape library Smith, Bob bob.smith@EDTo: [EMAIL PROTECTED] S.COM cc: (bcc: MUSTAFA BAYTAR/ATIM/ICECEK) Sent by: Subject: 3590 K-Cartridges on TSM 3.7.x ADSM: Dist Stor Manager [EMAIL PROTECTED] RIST.EDU 25.05.2001 12:14 Please respond to ADSM: Dist Stor Manager I'm being told by IBM that I need to go to TSM 4.1.1 to upport these. Is this correct? Is anyone using 3590 K-cartridges on TSM 3.7.x? Thanks Bob Smith
Re: DB2 6.1 TSM 4.1 SQL2062N 406 Errors attempting to backup
Set the following environment variables for users db2sid DSM_CONFIG=Drive:InstDir\baclient\dsm.opt DSM_DIR=Drive:InstDir\baclient DSM_LOG=Drive:\db2\SID\errors DSMI_CONFIG=Drive:InstDir\baclient\dsm.opt DSMI_DIR=Drive:InstDir\api DSMI_LOG=Drive:\db2\SID\errors MORGAN TONY TONY.MORGAN@FORTITo: [EMAIL PROTECTED] SBANK.COMcc: (bcc: MUSTAFA BAYTAR/ATIM/ICECEK) Sent by: ADSM: Subject: Re: DB2 6.1 TSM 4.1 SQL2062N 406 Errors attempting to Dist Stor Managerbackup [EMAIL PROTECTED] EDU 15.05.2001 19:29 Please respond to ADSM: Dist Stor Manager Sorry Richard... it does... still don't work though!! -Original Message- From: Richard Sims [mailto:[EMAIL PROTECTED]] Sent: 15 May 2001 16:31 To: [EMAIL PROTECTED] Subject: Re: DB2 6.1 TSM 4.1 SQL2062N 406 Errors attempting to backup The variables DSMI_DIR, DSMI_CONFIG and DSMI_LOG all point to c:\Program Files\Tivoli\TSM\baclient Tony - Shouldn't DSMI_CONFIG point to the options file itself, rather than the directory that it resides in? Richard Sims, BU
Re: 3494 Convenience I/O category
Ted , On your 3494 tape library DataServer Console swich to Service mode Then go to Availability - Set convenience I/O availability and check Conveninece I/O station box if not checked. Lindsay Morris lmorris@SERVERTo: [EMAIL PROTECTED] GRAPH.COM cc: (bcc: MUSTAFA BAYTAR/ATIM/ICECEK) Sent by: ADSM:Subject: Re: 3494 Convenience I/O category Dist Stor Manager [EMAIL PROTECTED] ST.EDU 14.05.2001 16:19 Please respond to lmorris Hi, Ted. Rebook SG24-4632 has what you want. www.redbooks.ibm.com, search for the number. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Ted Byrne Sent: Monday, May 14, 2001 9:02 AM To: [EMAIL PROTECTED] Subject: 3494 Convenience I/O category I'm trying to determine the number of tapes that are in the convenience I/O station of a 3494 tape library. I thought that I had found the answer on Richard Sims' QuickFacts page: 3494, count of cartridges inVia Unix command: Convenience I/O Station 'mtlib -l /dev/lmcp0 -vqK -s ff10' However, I'm having trouble getting the mtlib command to produce the results that I was looking for. When I run this command, I always get a count of 0 returned, even when we've just ejected tapes and they are still in the I/O station. The same is true if we've just inserted tapes into the I/O station, and they are still in the process of being stored in the cells. Am I missing something? Is the category FF10 correct for cartridges in the I/O station? When I query with other categories, I get the results that I'm expecting. Is there a master list of the valid categories for the 3494? Thanks in advance, Ted
Re: Restore DB2 and TSM and SQL2062
did your db2 backup finish successfuly whith which user you tray to make restore Felix MülbaierTo: [EMAIL PROTECTED] fmuelbai@TRAcc: (bcc: MUSTAFA BAYTAR/ATIM/ICECEK) NSCAT.DESubject: Restore DB2 and TSM and SQL2062 Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] RIST.EDU 11.05.2001 11:20 Please respond to ADSM: Dist Stor Manager Hi We had following problem. We installed aTSM at a customer. Client NT 4.0 Server NT4.0 with the latest Fixpacks. DSMI_DIR, DSMI_CONFIG and DSMI_CONFIG are set at My Computer Environments. DB2 is running under SAP/R3. We backed up the DB2 Database with a script : Setting the variables Stopping R3 db2stop then db2db6 backup database %SID% use adsm Now the Problem The Database is on a RAID5 - Disk System The System crashed and we got corrupt Files and two Tablespaces are offline. Now we want to do restore of the database from the DB2 control Center. Right Mouse Button on the Database P01 Restore Database. Medium ADSM We got the message : SQL2062N an error occured while accessing media H:\SQLLIB\bin\db2tadsm.dll Reason Code 2041 Does anyone have a TIP to solve the Problem. There is nothing in the dsierror.log. Thanks for Help Frendly Regards Felix Muelbaier mailto : [EMAIL PROTECTED] (weekdays) [EMAIL PROTECTED] (week-end)
Re: Antwort: Re: Restore DB2 and TSM and SQL2062
try to restore with user db2xxx (db2 admin user) Felix MülbaierTo: [EMAIL PROTECTED] fmuelbai@TRAcc: (bcc: MUSTAFA BAYTAR/ATIM/ICECEK) NSCAT.DESubject: Antwort: Re: Restore DB2 and TSM and SQL2062 Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] RIST.EDU 11.05.2001 12:46 Please respond to ADSM: Dist Stor Manager The Backup finished succesfully User=p01adm frendly regards Felix
Re: AIX Help
tray this (nohup /usr/tivoli/tsm/client/ba/bin/dsmc sched ) or look at the nohup.out file for error messages Chi, Hyeong [EMAIL PROTECTED]To: [EMAIL PROTECTED] OM cc: (bcc: MUSTAFA BAYTAR/ATIM/ICECEK) Sent by: Subject: Re: AIX Help ADSM: Dist Stor Manager [EMAIL PROTECTED] RIST.EDU 10.05.2001 01:17 Please respond to ADSM: Dist Stor Manager Off the . -Original Message- From: Dearman, Richard [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 6:14 PM To: [EMAIL PROTECTED] Subject: AIX Help I am trying to run the nohup dsmc sched 2 /dev/null command on my AIX 4.3.3 machine and it works but every time I exit. It says There are jobs running so I exit again and whe I check the dsmc sched process is not running. I thought the nohup command was suppose to let process run even after you logout. What am I doing wrong. Thanks ***EMAIL DISCLAIMER** This e-mail and any files transmitted with it may be confidential and are intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient or the individual responsible for delivering the e-mail to the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is strictly prohibited. If you have received this e-mail in error, please delete it and notify the sender or contact Health Information Management (312) 996-3941.
Re: 3494 checkin command
checkin libv 3494lib1 search=yes status=scratch devtype=3590 Dearman, Richard To: [EMAIL PROTECTED] rdearm1@UIC.cc: (bcc: MUSTAFA BAYTAR/ATIM/ICECEK) EDU Subject: 3494 checkin command Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] RIST.EDU 02.05.2001 19:43 Please respond to ADSM: Dist Stor Manager Anyone know the command on a 3494 library to checkin volumes using the barcode only. I added 300 new tape to my library and it wants to mount each one instead of just using the barcode. What is the typical command you guys use to check in new scratch tape on a 3494. Thanks ***EMAIL DISCLAIMER** This e-mail and any files transmitted with it may be confidential and are intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient or the individual responsible for delivering the e-mail to the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is strictly prohibited. If you have received this e-mail in error, please delete it and notify the sender or contact Health Information Management (312) 996-3941.
Re: SAP, DB2 and TSM
We are running SAP 40B with db2 6.1 and backing it up with TSM version 3.7 Collins, Brenda Brenda.Collins@WESTTo: [EMAIL PROTECTED] GROUP.COM cc: (bcc: MUSTAFA BAYTAR/ATIM/ICECEK) Sent by: ADSM: DistSubject: SAP, DB2 and TSM Stor Manager [EMAIL PROTECTED] U 26.04.2001 17:17 Please respond to ADSM: Dist Stor Manager Is anyone running SAP with DB2 and backing it up with TSM? If so, what versions of software are you using? We have version 7.1 UDB EEE but only backing it up with ADSM 3.1.06. The dba's think that we can not upgrade because SAP has not blessed any new versions and they may run into problems. Unfortunately, they are way out of support with TSM due to the level they choose to remain on. Does anyone know what version of TSM the SAP software recommends? Any help would be appreciated. Thanks, Brenda Collins, 651848-5808
Re: Amount of Data Backed Up Each Night
our TSM backed up to 450 GB per night "Diana J.Cline" Diana.Cline@ROSSNUTRTo: [EMAIL PROTECTED] ITION.COM cc: (bcc: MUSTAFA BAYTAR/ATIM/ICECEK) Sent by: "ADSM: Dist Subject: Amount of Data Backed Up Each Night Stor Manager" [EMAIL PROTECTED] 05.04.2001 20:39 Please respond to "ADSM: Dist Stor Manager" Is there anyone else out there who is backing up 300gb per night or more? If so, i'd love to converse with you.
Re: db2 backups not expiring
Peter logon to your aix system as user db2 or user who is owner the db2 backups and then run command : db2adutl query full you will show list of your db2backups then run command db2adutl delete full older than XX days. your db2 backups will not expire until you dont run this command "Glass, Peter" Peter.K.Glass@WELLSTo: [EMAIL PROTECTED] FARGO.COM cc: (bcc: MUSTAFA BAYTAR/ATIM/ICECEK) Sent by: "ADSM: DistSubject: db2 backups not expiring Stor Manager" [EMAIL PROTECTED] U 03.04.2001 23:28 Please respond to "ADSM: Dist Stor Manager" All, Does anybody know why wouldn't db2 backups expire, when, in theory, they should be? We have an AIX-SP environment, with TSM 4.1, server and clients. DB2 data is backed up via the TSM-API. The copygroup criteria for this data is: versions exists=1; versions deleted=1; retain extra versions=1, retain only version=3. DB2 backups have been occurring weekly since mid-November 2000, yet none of the DB2 backup images have ever expired. We run inventory expiration daily. Any ideas? Thanks! Peter Glass Distributed Storage Management (DSM) Wells Fargo Services Company * 612-667-0086 * 866-249-8568 * [EMAIL PROTECTED]