Informix backup problems...
I'm getting these errors intermittently... 12/21/05 03:40:57 Executing Operating System command or script: su informix "-c /home/bhsadmin/bin/backup_informix" 12/21/05 05:00:48 Finished command. Return code is: 19 12/21/05 05:00:48 ANS1909E The scheduled command failed. 12/21/05 05:00:48 ANS1512E Scheduled event 'PHAR_INFORMIX_NIGHTLY' failed. Return code = 19. Does a return code of 19 mean an authentication failure? If some could direct me to docs on TSM return code, I would be most appreciative. Also, some nights the backups with take under an hour, and other nights, up to 3 hours, which caused a vendor to complain that the system slows down almost to a halt. Ideas? TSM Server v5.3.1.2, AIX v5.2 TDP for Informix v4.1.3, AIX v4.3.3 God bless you!!! Chip Bell Network Engineer I IBM Tivoli Certified Deployment Professional (ITSM 5.2) Baptist Health System Birmingham, AL Office (205) 715-5106 Pager (205) 817-0357 Home (256) 739-0947 - Confidentiality Notice: The information contained in this email message is privileged and confidential information and intended only for the use of the individual or entity named in the address. If you are not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this information is strictly prohibited. If you received this information in error, please notify the sender and delete this information from your computer and retain no copies of any of this information.
Informix backup problem using TDP 5.2.1
Hi every one We have the following config : TSM server 5.2 over AIX 5.2 ml04 A client with TDP Informix 5.2.1 We receive an " unknown XBSA error" in the bar_actlog file when backing up our Informix database. Can you tell me if the versions compatibility is valid or give me your help to work around this ? . Youssef. === Ce message et toutes les pieces jointes (ci-apres le "message") sont confidentiels et etablis a l'intention exclusive de ses destinataires. Toute utilisation ou diffusion non autorisee est interdite. Tout message electronique est susceptible d'alteration. La SOCIETE GENERALE et ses filiales declinent toute responsabilite au titre de ce message s'il a ete altere, deforme ou falsifie. === This message and any attachments (the "message") are confidential and intended solely for the addressees. Any unauthorized use or dissemination is prohibited. E-mails are susceptible to alteration. Neither SOCIETE GENERALE nor any of its subsidiaries or affiliates shall be liable for the message if altered, changed or falsified. ===
Installing Tivoli Informix Backup Agent for TSM v5.2.2
> I'm currently encountering some issues trying to install the Tivoli > Informix backup agent. > > Some background info on the server: > > Server runs AIX 5.2 64-bit > Currently have a backup agent already installed and running. > > 1) When trying to run tdpipswd to register , I get the following error : > > *** > * TDP for Informix Backup * > * Password file initialization program* > *>> this must be run by the ROOT user if updating the value <<* > *** > Enter your current password: > Enter your new password: > *** Password failed: ANS1025E (RC137) Session rejected: Authentication > failure > > My dsm.sys and dsm.opt files are copies of the files used for the backup > agent, but copied to the apporpriate location for the Informix client to > pick up. Any ideas ? > > Also, is there a good instruction manual online on how to run the Informix > client ? The only Tivoli Informix manual I could find is the one named > Tivoli Data Protection for Informix Installation and User's Guide Version > 4 Release 1. It shows how to install, but then leaves off at actually > using the Informix client. > > Any help would be greatly appreciated. > > > This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately. Ce courriel est confidentiel et protégé. L'expéditeur ne renonce pas aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) désigné(s) est interdite. Si vous recevez ce courriel par erreur, veuillez m'en aviser immédiatement, par retour de courriel ou par un autre moyen.
Re: Informix backup
From: Mario Behring [mailto:[EMAIL PROTECTED] > I have to perform the backup of a Informix database and I > want to know if is possible for TSM to do it without the TDP > for Informix. > > I have been told that the ONBAR tool uses the XBSA libraries > to talk to SM products and that the only thing that the TDP > for Informix does is to act as a translator between TSM and > Informix. Is it true ? Actually, that's how all TDP agents work; they use the application's own backup facilities (virually all databases have one) to create a backup which is held long enough for TSM to suck it as a backup, and then is deleted. This is because Tivoli (quite wisely) decided a long time ago to make use of the OS and application interfaces. -- Mark Stapleton ([EMAIL PROTECTED])
Re: Informix backup
Hi Mario, My response against each question is below => Can I perform a database backup and later, if I wish, restore a specific tablespace using TSM (with or without the TDP?) ? Can you elaborate on this more ? * Can the ONTAPE tool be used (or commanded) from TSM ? ONTAPE tool is an independent backup/restore tool of Informix. You do not require TSM for this. Also ONTAPE can not be used with TSM. As per Informix, only ONBAR can be used with any Storage Manager Regards, Sachin Ganu IBM Global Services (India) Pvt. Ltd. E-mail : [EMAIL PROTECTED]
Informix backup
Hi list, I have to perform the backup of a Informix database and I want to know if is possible for TSM to do it without the TDP for Informix. I have been told that the ONBAR tool uses the XBSA libraries to talk to SM products and that the only thing that the TDP for Informix does is to act as a translator between TSM and Informix. Is it true ? Another issues: => Can I perform a database backup and later, if I wish, restore a specific tablespace using TSM (with or without the TDP?) ? => Can the ONTAPE tool be used (or commanded) from TSM ? Any information on how can I accomplish this is appreciated. Thanks. Mario __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com
Re: Informix backup
The tape to disk will work. But, onbar is an animal of its own. Version 3, Release 1, Level 0.7 (unsupported) came with xbsa interface that supported onbar, we have used it successfully. The xbsa interface is no longer a "feature" and a tdp for informix databases is needed. Aaron Durkee [EMAIL PROTECTED] phone: (716) 862-1713 fax: (716) 862-1717 Networking and Technical Group Western New York Catholic Health System >>> [EMAIL PROTECTED] 03/20/03 08:42AM >>> Hello Sure, no problem. We use a preschedulecommand to run ontape to backup to a file and the backup tat file using TSM. Regards Niklas -Original Message- From: Mario Behring [mailto:[EMAIL PROTECTED] Sent: den 20 mars 2003 14:39 To: [EMAIL PROTECTED] Subject: Informix backup Hi list, Can I use the native backup from Informix, OnBar, to perform its own backup and then use the TSM Backup/Archive Client to copy this data to a tape storage pool ? Has anybody done that ? The reason I ask is because we do not have the TDP for Informix to perform online backup with TSM. Thanks. Mario - Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
Re: Informix backup
If you want to use onbar for your backup, you have to use Storage Manager that makes use of XBSA. Onbar is meant to work that way Regards Sachin -Original Message- From: Mario Behring [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2003 7:09 PM To: [EMAIL PROTECTED] Subject:Informix backup Hi list, Can I use the native backup from Informix, OnBar, to perform its own backup and then use the TSM Backup/Archive Client to copy this data to a tape storage pool ? Has anybody done that ? The reason I ask is because we do not have the TDP for Informix to perform online backup with TSM. Thanks. Mario - Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
Re: Informix backup
Hello I'm not an Informix dba either...But it's pretty straigt forward This is the backupcommand that we run as a preschedulercommand: onmode -uy shutdown of database ontape -s -L 0 < E:\server\scripts\enter.txt When you run ontape you have to press enter, the enter.txt files contain one enter onmode -mstarts the database There are more cmdfiles involved since we are renaming the backupfiles and moves them to another directory because the backup always goes to the same file, backup.bup, and to save the backup you have to copy and rename that file. The onconfig looks like this: # System Archive Tape Device #TAPEDEV\\.\TAPE0 # Tape device path TAPEDEV L:\Backserv\Backup.bup # Tape device path TAPEBLK 16 # Tape block size (Kbytes) TAPESIZE200 # Maximum amount of data to put on tape (Kbytes) We used to run onbar but the dba wanted to restore single tables and to do that you had to shutdown the database and run ontape , don't ask me why it couldn't be done with onbar.. Regards Niklas -Original Message- From: Mario Behring [mailto:[EMAIL PROTECTED] Sent: den 20 mars 2003 15:33 To: [EMAIL PROTECTED] Subject: Re: Informix backup Hi Niklas, Can you be more specific ? What is this preschedule command you use ? Sorry, I am no Informix DBA. Thanks. Best regards, Mario Niklas Lundstrom <[EMAIL PROTECTED]> wrote:Hello Sure, no problem. We use a preschedulecommand to run ontape to backup to a file and the backup tat file using TSM. Regards Niklas -Original Message- From: Mario Behring [mailto:[EMAIL PROTECTED] Sent: den 20 mars 2003 14:39 To: [EMAIL PROTECTED] Subject: Informix backup Hi list, Can I use the native backup from Informix, OnBar, to perform its own backup and then use the TSM Backup/Archive Client to copy this data to a tape storage pool ? Has anybody done that ? The reason I ask is because we do not have the TDP for Informix to perform online backup with TSM. Thanks. Mario - Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! - Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
Re: Informix backup
Hi Niklas, Can you be more specific ? What is this preschedule command you use ? Sorry, I am no Informix DBA. Thanks. Best regards, Mario Niklas Lundstrom <[EMAIL PROTECTED]> wrote:Hello Sure, no problem. We use a preschedulecommand to run ontape to backup to a file and the backup tat file using TSM. Regards Niklas -Original Message- From: Mario Behring [mailto:[EMAIL PROTECTED] Sent: den 20 mars 2003 14:39 To: [EMAIL PROTECTED] Subject: Informix backup Hi list, Can I use the native backup from Informix, OnBar, to perform its own backup and then use the TSM Backup/Archive Client to copy this data to a tape storage pool ? Has anybody done that ? The reason I ask is because we do not have the TDP for Informix to perform online backup with TSM. Thanks. Mario - Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! - Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
Re: Informix backup
Hello Sure, no problem. We use a preschedulecommand to run ontape to backup to a file and the backup tat file using TSM. Regards Niklas -Original Message- From: Mario Behring [mailto:[EMAIL PROTECTED] Sent: den 20 mars 2003 14:39 To: [EMAIL PROTECTED] Subject: Informix backup Hi list, Can I use the native backup from Informix, OnBar, to perform its own backup and then use the TSM Backup/Archive Client to copy this data to a tape storage pool ? Has anybody done that ? The reason I ask is because we do not have the TDP for Informix to perform online backup with TSM. Thanks. Mario - Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
Informix backup
Hi list, Can I use the native backup from Informix, OnBar, to perform its own backup and then use the TSM Backup/Archive Client to copy this data to a tape storage pool ? Has anybody done that ? The reason I ask is because we do not have the TDP for Informix to perform online backup with TSM. Thanks. Mario - Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
Informix backup using IBM 3494
Hi I have RS/6000 SP2 wide node with AIX 4.3.3 attached to ESS storage box having Informix database 7.24 UC3. We backup this database using TDP for Informix version 3.7 with ON-Bar. We use the command "onbar -b -L 0" to backup whole database and also backup logical log. We restore it at Disaster recovery site using this database backup with logical logs. Presently we have db size of 240 GB is backed up in 4 hrs. We want to speed up the backup using by buying 3494 with two drives inside. With onbar -b -L 0 command , using BAR_MAX_BACKUP parameter we can have parallel onbar processes (one onbar process per dbspace). I checked out with Informix support and they say that Informix engine has no control for sending onbar data to 3494. Has anybody implemented 3494 with parallel backup and how onbar is sending data to 3494 drives ? Since 3494 is very expensive, we want to make sure the solution works before we buy it Thanks & regards Sachin Ganu IBM Global Services (India)
Informix backup query
Hi I have a question. I backup informix database 7.24 UC3 on SAP R/3 using TSM 3.7 using onbar -b -w -L 0. It shows me total backed up database as 172 GB whereas my Informix utility using sapdba shows 190 GB (excluding tmpdbs), can some one tell me why is the difference ? Regards Sachin Ganu IBM Global Services (India) C/o Siemens Kalwa Data Center (BVQI certfied ISO9002)