Re: can't over the 30 GB on tape.
I have adsm 3.1 on aix 4.2.1 with DLT library. On the library I have 3 stgpool NT,UNIX and Oracle. After having a space problem on the library we decided to upgrade the 20/40GB tape drive to 35/70GB tape drive and start labeling all the volumes. The problem is that in the unix stgpool I can see 35G capacity on the volume some time more then that, but on the NT stgpool the capacity on the volume can't get over the 30GB per volume with status full pct 98%. The IBM guy's told me to change the drive format from fromat=drive to fomat=dlt35, but this didn't help. I told them that the problem is only on the NT stgpool there is no problem on the unix stgpool. The IBM guys might instead have advised specifying Format=DLT35C if they thought there was a problem with Format=DRIVE. But: Are your clients doing their own compression...? Richard Sims, BU
AIX device drives
Hi *SM-ers! I'm preparing for an upgrade of my TSM server. As soon as it's available (I thought I've read June 29th. somewhere, but apparently not) I will upgrade my 3.7 server to 4.2. I will use that maintenance slot to upgrade several AIX device drivers too. Now I'm looking for devices.fcp.tape.rte, the fibre channel attached tapes device driver. I found most of the drivers at ftp://techsupport.services.ibm.com/aix/fixes/v4/devices/ but this one is not there. Does anybody know an alternative download site for this file? Thank you very much in advance! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
TDP for SAP/R3 with DB2
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: 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: TDP for SAP/R3 with DB2
I'm not familiar with DB2 but am far too familiar with backint/TDP for SAP/R3. Backint does a two-phase backup. The first phase actually does the database backup of all the SAPDATA files. All actions are recorded in an /oracle/SID/sapbackup/encoded timestamp.anf or .aff file, and this filename is logged in /oracle/SID/sapbackup/backSID.log. The second phase copies both of these files, a structure file (/oracle/SID/sapreorg/structSID.log), a reorg log file (/oracle/SID/sapreorg/reorgSID.log), the backint parm file (/oracle/SID/dbs/initSID.utl), the SAP non-database init file (/oracle/SID/dbs/initSID.sap), the SAP database init file (/oracle/SID/dbs/initSID.dba) and the Oracle init file (/oracle/SID/dbs/initSID.ora). This phase is backing up everything you need to know to re-create the SAP instance. And I think this is the heart of Manoel's question -- are the equivalent DB2 files backed up with the TSM - DB2 interface? Not that I think it is important. Manoel, I've been through a number of successful D/R tests with full SAP recovery, including recovery from an incremental backup and a number of off-line redo logs. We archive the /oracle/SID and /sapmnt/SID filesystems weekly to the same management classes as our offline redo logs. At D/R time we rebuild the filesystems, retrieve the most recent archives, and then do a point in time restore of them before trying the SAP restore. The whole second phase of backint is almost unneeded. (We do use backfm to retrieve the most recent archSID.log and matching .svd files). Tom Kauffman NIBCO, Inc -Original Message- From: MUSTAFA BAYTAR [mailto:[EMAIL PROTECTED]] Sent: Monday, July 02, 2001 7:58 AM To: [EMAIL PROTECTED] Subject: 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.
John Johnson/Seattle/IBM is out of the office.
I will be out of the office starting July 2, 2001 and will not return until July 9, 2001. I will respond to your message when I return.
Re: Tape Volume full with UtilPct in 0% and status filling
The CPF* error messages will be logged on the 400. You can do a DSPLOG, scroll through the log, and hit F1 on the CPF error and it should bring up a short explanation and troubleshooting suggestions for the error. It is possible that these errors are meaningless and are just ancillary results of your ANR8214E message. Your client is refusing the session for some reason, try troubleshooting that error message first. John Monahan Senior Consultant Enterprise Solutions Computech Resources, Inc. Office: 952-833-0930 ext 26 Cell: 952-484-5435 http://www.compures.com Angelica Tulipano To: [EMAIL PROTECTED] atulipan@GBMcc: .NETSubject: Tape Volume full with UtilPct in 0% and status filling Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] RIST.EDU 06/29/2001 03:11 PM Please respond to ADSM: Dist Stor Manager Hi! I have a TSM v3.1 on AS/400, and i'm having this problem, seems like the tape volume is full, but is in a filling state with a util percentil of 0%, and is imposible to be full, someone of you have any idea how to solve this, also do you know where i can get what means a CPF?: 06/27/2001 02:17:40 ANR8328I 244: 3570 volume 03E99F mounted in drive TAPMLB1 (DRVRSRC). 06/27/2001 02:17:53 ANR8214E Session open with 10.1.1.26 failed due to connection refusal. 06/27/2001 02:18:02 ANR8341I End-of-volume reached for 3570 volume 03E99F. 06/27/2001 02:18:02 ANR7808W FLUSH TAPE 03E99F returned exception CPF5386. 06/27/2001 02:18:03 ANR7808W CLOSE TAPE 03E99F returned exception CPF4405. 06/27/2001 02:18:10 ANR8468I 3570 volume 03E99F dismounted from drive TAPMLB1 (DRVRSRC) in library TAPMLB1. Ing. Angélica Tulipano GBM de Panamá, S.A. Phone (507) 263-9977 ext 202 Fax (507) 269-3604 e-mail: [EMAIL PROTECTED]
Re: ADSM 3.1.2.90 on AIX 4.3.3-06
I'll take a stab at a possible solution if you haven't found a solution yet. As we upgraded our ADSM servers to latter versions of the OS and the TSM server software, we experienced significant slowdowns on the system especially when there were multiple sessions or processes going on. We eventually found our answer in the readme file for the TSM server. I believe this bit us when we upgraded the OS as you did. Here are some notes from the readme file for version 4.1.1. ___ ** * Possible performance degradation due to threading * ** On some systems Tivoli Storage Manager for AIX may exhibit significant performance degradation due to TSM using user threads instead of kernel threads. This may be an AIX problem however, to avoid the performance degradation you should set the following environment variables before you start the server. export AIXTHREAD_MNRATIO=1:1 export AIXTHREAD_SCOPE=S ___ Not having these 2 settings basically turns your multi-threading machine into a single-threaded process and performance really gets bad. Making these changes don't require a reboot, so it's worth a shot to add these in, make sure they get sourced into your current environment (by logging out back in, or just running these 2 lines) and then stop and start the ADSM service. Ben Bullock Unix system manager Micron Technology Inc. -Original Message- From: irene [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 27, 2001 9:54 AM To: [EMAIL PROTECTED] Subject: ADSM 3.1.2.90 on AIX 4.3.3-06 We were running ADSM 3.1.2.90 on AIX 4.2.1 and it behaved normally. When we migrated AIX to 4.3.3-06, ADSM slowed down to unacceptable response times. For example, a backup that used to take 5 minutes now takes 50 minutes. The operating system seems to be performing O.K. All of this is being done on a test machine at the moment. Does anyone have any ideas why this is happening? Should we have done a complete overwrite rather than a migrate when moving to AIX 4.3.3-06 from AIX 4.2.1? Thank-you for any insight provided. Irene Braun EMAIL: [EMAIL PROTECTED]
Archive files which are not referenced during last xx months
Hi, I would like to do following, but I do not know if this is possible Client is WinNT file server running TSM 4.1 1. Check which files are not referenced since xx months 2. Archive those files 3. Delete files on the fileserver after they have been archived Anybody any idea ? Thanks, Van de Vijver Paul Honda Europe NV Belgium
DB2 Restores to Different DB / Node Using TSM
Hello: I am new to the list and have a question for the other list subscribers who use TSM to backup restore DB2 UDB databases. We currently are running DB2 UDB v5.2 on AIX (soon to be upgraded to DB2 UDB v7.2) and TSM v4.1, also on AIX. We have had TSM installed for only 3 weeks, and are therefore not yet in production. Once in production, we will be using TSM to backup our databases online will be using the delivered DB2 user exit program to automatically archive our transaction log files to TSM. During my testing, I have identified an issue (for us anyway) with restoring databases. The vast, vast majority of the time we restore a given database, it is to a different database, with a different name, on a different TSM client (I won't go into the reasons for this - just suffice it to say we have to do this *a lot*). I have been referring to a excellent new IBM RedPiece just published this May titled Backing up DB2 Databases Using Tivoli Storage Manager. According to this book, the mechanics that we would have to go through to restore a given database to a different database on a different TSM client are pretty ugly. The restore itself isn't too bad (just set a couple of database level cfg parameters), but performing the subsequent ROLLFORWARD in order to make the restored database useable is where it gets really ugly - modifying the user exit, recompiling it, and doing the ROLLFORWARD - then changing the user exit back again. And, this will only work if the target database has the exact same name as the source database. Is there not a better way to accomplish this? Are there any third party tools that would make this process less painful more seamless? Any and all help / suggestions would be most appreciated. Thanks! Tom Tracy Sr. Database Administrator NTRC, LLC. [EMAIL PROTECTED]
TSM 4.2
Hello! The 4.2-clients have been available on the ftp-server since Saturday. Anyone know why the 4.2-servers still are missing? GA was on July 1. for both? The AIX-server is the one I'm waiting for..
Redirecting Output In Scripts
I am having a bit of bother routing output from a script to a file in an AIX environment. (I am fairly new to AIX having been an MVS/OS390 junky for 20 odd years !) Currently we have an ADSM 3.1.2.50 (yes I know we are out of support - upgrade to TSM 4.1 pending !!) on OS390 and an AIX server at TSM 3.7.2. In the ADSM server, I can execute a SELECT command in Batch TSO Admin as follows : SELECT NODE_NAME,VOLUME_NAME FROM VOLUMEUSAGE - 'DM.PROD.ADSMP.VOLUSAGE' The output goes to the OS390 dataset as expected. However, in the TSM server on AIX, a similar command defined as a script and then run issues an ANR2907E Unexpected SQL operator token - ''. eg : select node_name, volume_name from volumeusage /adsmlogs/output.file If you run the same command in a command line admin client session (dsmadmc), the command does redirect the output okay !! How can I get the output redirected in a script ? I want to automate several scripts, redirecting the output to files which I can post-process on OS390 with SAS. Thanks Robin Lowe Senior Storage Analayst For more information on Standard Life, visit our website http://www.standardlife.com/ The Standard Life Assurance Company, Standard Life House, 30 Lothian Road, Edinburgh EH1 2DH, is registered in Scotland (No SZ4) and regulated by the Personal Investment Authority. Tel: 0131 225 2552 - calls may be recorded or monitored. This confidential e-mail is for the addressee only. If received in error, do not retain/copy/disclose it without our consent and please return it to us. We virus scan all e-mails but are not responsible for any damage caused by a virus or alteration by a third party after it is sent.
Database backup performance
I want to thank everyone who responded to my question(s). It seems that *EVERYONE* goes faster than us, some by a big margin. I just finished upgrading the OS/390 server from ADSM 3.1.2.50 to TSM 4.1.3. I was hoping the DB backup would be faster. Unfortunately, there is no joy in Mudville. The first full DB backup performed after the upgrade took 4h 43m. I am still looking for suggestions on how to improve these numbers. Changing the backup to 3590 drives/tapes only shaved about 20 minutes off the time. That mostly accounts for rewind and mount times (1-3590 vs 9-3490). I have bumped the BUFPOOLSIZE value to 80M but still cant achieve the elusive 98+% Cache Hit Pct.. I've thought about trying SELFTUNEBUFPOOLSIZE but am a little concerned since we are currently somewhat real-storage constrained and TSM is currently at over 120M WSS, already. Anyone have any experience with this new option ? Any suggestions/tips to improve the DB backup performance ? f adsm,q db f=d ANR5965I Console command: Q DB F=D Available Space (MB): 17,496 Assigned Capacity (MB): 17,496 Maximum Extension (MB): 0 Maximum Reduction (MB): 3,020 Page Size (bytes): 4,096 Total Usable Pages: 4,478,976 Used Pages: 3,700,667 Pct Util: 82.6 Max. Pct Util: 82.6 Physical Volumes: 8 Buffer Pool Pages: 20,480 Total Buffer Requests: 63,986,411 Cache Hit Pct.: 95.31 Cache Wait Pct.: 0.00 Backup in Progress?: No Type of Backup In Progress: Incrementals Since Last Full: 0 Changed Since Last Backup (MB): 376.67
Change IP Address
For the AIX crowd out there, I need to change the IP address on my ADSM server this weekend. I want to know if there are any pitfalls I should look out for. It's not just an IP change on the same network, I'll be changing the IP, NETMASK and Default Gateway. Questions: Since I'm not totally AIX literate yet is there a command line command I can use that will do all 3 at once? Should I plan on rebooting the box after this change? Thanks for the help. Geoff Gill TSM Administrator NT Systems Support Engineer SAIC E-Mail: [EMAIL PROTECTED] Phone: (858) 826-4062 Pager: (888) 997-9614
RSM
Hello! I have had backup failure on one particular Windows 2000 server running a TSM client 41212. The errors began after SP 2 installation and have to do with RSM. Backup fails completely. Has anyone come across the same problem? Thanks in advance. Mohamed ** This footnote confirms that this email message has been swept by MIMEsweeper for the presence of known computer viruses. Denne mailen er sjekket for kjente virus, uten at noen ble funnet. http://www.hydrotexaco.no **
cuSignOnResp: Server rejected session; result code: 53
Can't remember this one being mentioned and I didn't find anything on a search of adsm.org so I though I'd toss this to the group... anyone seen this in their client dsmerror.log ? 06/15/01 15:41:32 cuSignOnResp: Server rejected session; result code: 53 AIX 4.3.3 server running TSM 3.7.2 and the clients seem to mainly be sun solaris 6 with tsm 3.7.2.0 client code hugh amounts of zero activity sessions from client to server (they have nothing to do with the scheduler) 3,0,ADSM,07/01/2001,00:50:33,SUNDEV1,oracle,SUN SOLARIS,1,Tcp/Ip,1,0,0,0,0,0,0,0,0,3,7,7,0,0,4,0,0,0,0,7,2 3,0,ADSM,07/01/2001,11:31:32,TDCCDPD1,,SUN SOLARIS,1,Tcp/Ip,1,0,0,0,0,0,0,0,0,1,0,0,0,0,4,0,0,0,0,7,2 Even if root simply initiates a dsmc session and then does anything to contact the server (such as a q sched) it opens a session that terminates, writes the record to the dsmerror.log and then performs the desired action and gives the proper info back to the dsmc session BUT each action initiates at least two sessions. Is a little bit of a pain because after only being up for 45 days, this specific tsm server is on client session 985,043 The accounting log is rather large. I know... 4.1 or 4.2, I'll head there quick enough but this seems to have started out of the blue a couple months ago and I haven't figured it out yet... any thoughts ? Dwight
Re: AIX device drives
Eric, According to the search facility at the following page: http://techsupport.services.ibm.com/rs6k/fixdb.html there does not appear to be any updates to devices.fcp.tape.*. We have ML_07 applied to our systems, and they show devices.fcp.tape.rte at 4.3.3.0. June 29th is the correct GA date for 4.2. You should receive a letter from Tivoli instructing you to contact [EMAIL PROTECTED] to have it shipped to you. HTH, Ted
Re: can't over the 30 GB on tape.
Or is the NT drive a compressed drive? Or MS-Exchange, with a compressed information store? I routinely get about 100 GB of SAP/Oracle on a DLT 7000, with Format=DRIVE. OTOH, I max ot at about 68 GB with NT (as seen from the TSM server) and at 30 GB the tape will go FULL if I'm backing up MS-Exchange. If you have the network capacity, don't do TSM client compression; let the tape drive do the data compression. Tom Kauffman NIBCO, Inc -Original Message- From: Richard Sims [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 01, 2001 7:52 AM To: [EMAIL PROTECTED] Subject: Re: can't over the 30 GB on tape. I have adsm 3.1 on aix 4.2.1 with DLT library. On the library I have 3 stgpool NT,UNIX and Oracle. After having a space problem on the library we decided to upgrade the 20/40GB tape drive to 35/70GB tape drive and start labeling all the volumes. The problem is that in the unix stgpool I can see 35G capacity on the volume some time more then that, but on the NT stgpool the capacity on the volume can't get over the 30GB per volume with status full pct 98%. The IBM guy's told me to change the drive format from fromat=drive to fomat=dlt35, but this didn't help. I told them that the problem is only on the NT stgpool there is no problem on the unix stgpool. The IBM guys might instead have advised specifying Format=DLT35C if they thought there was a problem with Format=DRIVE. But: Are your clients doing their own compression...? Richard Sims, BU
Re: label libv hang
Jeff, two thoughts 1. Make sure there are tape drives available. If all are occupied, the label process will just sit there. But this shouldn't cause queries to hang 2. Try ps -ef|grep dsmadmc at the AIX command line. These are admin sessions... if you see more than you know or think should be active, kill -9 them... We've had this situation happen. One of the rogue admin sessions is a bottleneck, and removing it may free things up. 3. (bonus) we also had a situation just the other day (in fact on 6/29!) where TSM server got hopelessly lost we couldn't even get a password prompt when starting dsmadmc halting and restarting TSM didn't help, we had to reboot AIX, then it was OK. Robin Sharpe Berlex Laboratories Jeff Bach jdbach@WAL-M ART.COM To:[EMAIL PROTECTED] cc:(bcc: Robin Sharpe/WA/USR/SHG) 06/29/01 Subject: 05:35 PM Please respond to ADSM: Dist Stor Manager Help, I am running a 3.1.2.41 ADSM server on AIX 4.3.2. After trying to label a library volume with a label libvol command, the command hung. Now q pro, q libr, and other commands hang. Is there a solution other that bouncing the ADSM instance? (the application) Jeff Bach Home Office Open Systems Engineering Wal-Mart Stores, Inc. WAL-MART CONFIDENTIAL ** This email and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. If you have received this email in error destroy it immediately. **
Sometimes network shared drives on NT servers don't backup .WHY?
TSM Gurus, I have problem on TSM NT CLIENTS ,i.e. Sometimes network drives of client doesn't get backed up. C: drive gets backed up.But the network drives doesn't. Any ideas?HP/SUN/AIX clients are backing up ok. It doesn't seem to be network problem.
