TSM and Informix 11.10 on Windows

Hi, We have installed recently IDS 11.10 TC30 on windows 2003 enterprise edition. We have also Tivoli server installed WE are trying to backup using onbar to TSM server. TSM server version 5.3.4 and TSM client 6. We have followed some papers about the TSM,IDS and onbar configuration. From TSM log we can see that TSM client is connected to TSM server and moumts a tape. on_bar log contains except the other 2010-09-01 12:07:47 2432 2432 (-43078) Open or close failed on file 'C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.10\\\\etc\\\\ixbar.0', errno = 2 . No such file or directory 2010-09-01 12:07:47 2432 2432 Begin level 0 backup rootdbs. 2010-09-01 12:07:52 2432 2432 Successfully connected to Storage Manager. 2010-09-01 12:08:20 2432 2432 XBSA Error (BSAQueryObject): An unspecified XBSA error has occured: 117768210 Question 1 Does ixbar. file must already exist on IDS or it will be created after the first backup? I have run onsmsync -b (end it successfully) but still no ixbar. file created. Question 2. Does the second error XBSA is the real problem? Following are some information to may be help you We trying to use onbar -b -w ή onbar -b -L0 commands Informix onconfig has the following definition for onbar # Backup/Restore variables BAR_ACT_LOG C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.10\\\\bar_ol_primetest.log #Path of log file for onbar.exe BAR_DEBUG_LOG C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.10\\\\bar_ol_primetest.log #Path of the debug log for onbar.exe BAR_MAX_BACKUP 0 BAR_RETRY 1 BAR_NB_XPORT_COUNT 20 BAR_XFER_BUF_SIZE 15 BAR_PROGRESS_FREQ 0 BAR_BSALIB_PATH C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.10\\\\bin\\\\libtxbsa.dll # Location ofTSM XBSA DLL Thanks in advance SZ

Hello SZ, Issue 1: The ixbar.xxx file is a file where Informix keeps track of it's backups. It is the external version of the sysutils database. There seems to be an initial check on the existence of this file, which fails (errno 2 = not exists). The file should be created if it does not exist. Check if there is a problem with access rights settings in the directory. Issue 2: An unspecified XBSA error can occur for various reasons. It will help, if you provide the XBSA error number. The number specified in the appended mail '117768210' is out of reach. Please verify the following : 1. 'sm_versions' file exists under $INFORMIXDIR/etc and has the right entry for TSM 2. Environment variables 'DSMI_DIR', 'DSMI_LOG' and 'DSMI_CONFIG' are set to the right entries and are in the PATH 3. 'DSMI_LOG' has right Read/Write access permission Also, provide the output of 'dsierror.log' file Thanks, Prasanna Alur Mathada Informix -Interoperability India Software Lab, IBM Software Group ------------------------------------------- Ph : Extn : 91-80-280-60954 From: "SERGIOS ZAGOTSIS" <szagotsis@marfinbank.gr> To: ids@iiug.org Date: 02/09/2010 03:43 Subject: TSM and Informix 11.10 on Windows [21109] Sent by: ids-bounces@iiug.org Hi, We have installed recently IDS 11.10 TC30 on windows 2003 enterprise edition. We have also Tivoli server installed WE are trying to backup using onbar to TSM server. TSM server version 5.3.4 and TSM client 6. We have followed some papers about the TSM,IDS and onbar configuration. >From TSM log we can see that TSM client is connected to TSM server and moumts a tape. on_bar log contains except the other 2010-09-01 12:07:47 2432 2432 (-43078) Open or close failed on file 'C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.10\\\\etc\\\\ixbar.0', errno = 2 . No such file or directory 2010-09-01 12:07:47 2432 2432 Begin level 0 backup rootdbs. 2010-09-01 12:07:52 2432 2432 Successfully connected to Storage Manager. 2010-09-01 12:08:20 2432 2432 XBSA Error (BSAQueryObject): An unspecified XBSA error has occured: 117768210 Question 1 Does ixbar. file must already exist on IDS or it will be created after the first backup? I have run onsmsync -b (end it successfully) but still no ixbar. file created. Question 2. Does the second error XBSA is the real problem? Following are some information to may be help you We trying to use onbar -b -w &#942; onbar -b -L0 commands Informix onconfig has the following definition for onbar # Backup/Restore variables BAR_ACT_LOG C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.10\\\\bar_ol_primetest.log #Path of log file for onbar.exe BAR_DEBUG_LOG C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.10\\\\bar_ol_primetest.log #Path of the debug log for onbar.exe BAR_MAX_BACKUP 0 BAR_RETRY 1 BAR_NB_XPORT_COUNT 20 BAR_XFER_BUF_SIZE 15 BAR_PROGRESS_FREQ 0 BAR_BSALIB_PATH C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.10\\\\bin\\\\libtxbsa.dll # Locationof TSM XBSA DLL Thanks in advance SZ ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Also watch for 32 bit vs 64 bit files for: 2. Environment variables 'DSMI_DIR', 'DSMI_LOG' and 'DSMI_CONFIG' are set to the right entries and are in the PATH They could be different and need to be set correctly. Thanks, ******************************************************************* Ernie Knox IT Database Administrator Specialist Sears Holdings - BU: I & T Group 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry: 2244650553@messaging.sprintpcs.com Page via Skytel: 2244650553@sprint.skytel.com Informix or MySQL Primary: 9110210@skytel.com Informix or MySQL Secondary: 7276872@skytel.com " Yes we can make a Change! " " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! " " Lets not forget - GO Pistons and Red Wings! " GSU ******************************************************************* -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Prasanna A Mathada Sent: Thursday, September 02, 2010 2:02 AM To: ids@iiug.org Subject: Re: TSM and Informix 11.10 on Windows [21114] Hello SZ, Issue 1: The ixbar.xxx file is a file where Informix keeps track of it's backups. It is the external version of the sysutils database. There seems to be an initial check on the existence of this file, which fails (errno 2 = not exists). The file should be created if it does not exist. Check if there is a problem with access rights settings in the directory. Issue 2: An unspecified XBSA error can occur for various reasons. It will help, if you provide the XBSA error number. The number specified in the appended mail '117768210' is out of reach. Please verify the following : 1. 'sm_versions' file exists under $INFORMIXDIR/etc and has the right entry for TSM 2. Environment variables 'DSMI_DIR', 'DSMI_LOG' and 'DSMI_CONFIG' are set to the right entries and are in the PATH 3. 'DSMI_LOG' has right Read/Write access permission Also, provide the output of 'dsierror.log' file Thanks, Prasanna Alur Mathada Informix -Interoperability India Software Lab, IBM Software Group ------------------------------------------- Ph : Extn : 91-80-280-60954 From: "SERGIOS ZAGOTSIS" <szagotsis@marfinbank.gr> To: ids@iiug.org Date: 02/09/2010 03:43 Subject: TSM and Informix 11.10 on Windows [21109] Sent by: ids-bounces@iiug.org Hi, We have installed recently IDS 11.10 TC30 on windows 2003 enterprise edition. We have also Tivoli server installed WE are trying to backup using onbar to TSM server. TSM server version 5.3.4 and TSM client 6. We have followed some papers about the TSM,IDS and onbar configuration. >From TSM log we can see that TSM client is connected to TSM server and moumts a tape. on_bar log contains except the other 2010-09-01 12:07:47 2432 2432 (-43078) Open or close failed on file 'C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.10\\\\etc\\\\ixbar.0', errno = 2 . No such file or directory 2010-09-01 12:07:47 2432 2432 Begin level 0 backup rootdbs. 2010-09-01 12:07:52 2432 2432 Successfully connected to Storage Manager. 2010-09-01 12:08:20 2432 2432 XBSA Error (BSAQueryObject): An unspecified XBSA error has occured: 117768210 Question 1 Does ixbar. file must already exist on IDS or it will be created after the first backup? I have run onsmsync -b (end it successfully) but still no ixbar. file created. Question 2. Does the second error XBSA is the real problem? Following are some information to may be help you We trying to use onbar -b -w &#942; onbar -b -L0 commands Informix onconfig has the following definition for onbar # Backup/Restore variables BAR_ACT_LOG C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.10\\\\bar_ol_primetest.log #Path of log file for onbar.exe BAR_DEBUG_LOG C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.10\\\\bar_ol_primetest.log #Path of the debug log for onbar.exe BAR_MAX_BACKUP 0 BAR_RETRY 1 BAR_NB_XPORT_COUNT 20 BAR_XFER_BUF_SIZE 15 BAR_PROGRESS_FREQ 0 BAR_BSALIB_PATH C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.10\\\\bin\\\\libtxbsa.dll #Location of TSM XBSA DLL Thanks in advance SZ ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.

Hi, I have managed to get rid off some problems 1. Reindtal TSM client and made changes on DSMI_DIR, DSMI_LOG parameters. 2. run successfully txbsapswd. 3. Now ixbar. file was created successfully. 4. define the DSMI_DIR, DSMI_LOG, DSMI-CONFIG variables and add to the PATH their directories. 5. I have not made any definition in dsm.sys about INCLEXL file 6. I gave the onbar -b -L0 and I got the following error ' 2010-09-02 15:47:43 4060 4060 C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.10\\\\bin\\\\onbar_d -b -w 2010-09-02 15:47:43 4060 4060 (-43336) Logical Logs cannot be backed-up because the database server is dismissing the logical logs.' When I gave the onbar -b -w command I hade the same error on on_bar log but onbar competed successfully. What is about this error? Does it has to do with include/exclude file? Thanks in advance Sergios

Our logs are being backed up after setting and bounce the instance with: informix@server [/usr/informix]: $onstat -c | grep log_full ALARMPROGRAM $INFORMIXDIR/etc/log_full.sh informix@server [/usr/informix]: $onstat -c | grep TAPE # TAPEDEV - The tape device path for backups. To use standard # TAPEBLK - The tape block size, in KB, for backups # TAPESIZE - The maximum amount of data to put on one backup # positive integral multiple of TAPEBLK. TAPEDEV /dev/null TAPEBLK 32 TAPESIZE 0# LTAPEDEV - The tape device path for logical logs # LTAPEBLK - The tape block size, in KB, for backing up logical # LTAPESIZE - The maximum amount of data to put on one logical # positive integral multiple of LTAPEBLK. LTAPEDEV /ifmx_backup/ifmx11501/ifmx11501.log LTAPEBLK 1024 LTAPESIZE 2048000 Thanks, ******************************************************************* Ernie Knox IT Database Administrator Specialist Sears Holdings - BU: I & T Group 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry: 2244650553@messaging.sprintpcs.com Page via Skytel: 2244650553@sprint.skytel.com Informix or MySQL Primary: 9110210@skytel.com Informix or MySQL Secondary: 7276872@skytel.com " Yes we can make a Change! " " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! " " Lets not forget - GO Pistons and Red Wings! " GSU ******************************************************************* -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of SERGIOS ZAGOTSIS Sent: Thursday, September 02, 2010 9:14 AM To: ids@iiug.org Subject: Re: RE: TSM and Informix 11.10 on Windows [21124] Hi, I have managed to get rid off some problems 1. Reindtal TSM client and made changes on DSMI_DIR, DSMI_LOG parameters. 2. run successfully txbsapswd. 3. Now ixbar. file was created successfully. 4. define the DSMI_DIR, DSMI_LOG, DSMI-CONFIG variables and add to the PATH their directories. 5. I have not made any definition in dsm.sys about INCLEXL file 6. I gave the onbar -b -L0 and I got the following error ' 2010-09-02 15:47:43 4060 4060 C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.10\\\\bin\\\\onbar_d -b -w 2010-09-02 15:47:43 4060 4060 (-43336) Logical Logs cannot be backed-up because the database server is dismissing the logical logs.' When I gave the onbar -b -w command I hade the same error on on_bar log but onbar competed successfully. What is about this error? Does it has to do with include/exclude file? Thanks in advance Sergios ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.

Hi, Where I can find XBSA error codes and their meaning? What measns '1768 XBSA Error (BSAQueryObject):'? Thanks Sergios

You could start here. https://www.ibm.com/developerworks/data/library/techarticle/dm-0603herber/ http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp?topic=/com.ibm.b ar.doc/ids_bar_447.htm&resultof=%22xbsa%22 On Fri, Sep 3, 2010 at 8:08 AM, SERGIOS ZAGOTSIS <szagotsis@marfinbank.gr>wrote: > Hi, > > Where I can find XBSA error codes and their meaning? > > What measns '1768 XBSA Error (BSAQueryObject):'? > > Thanks > > Sergios > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0016e64c1f4e2bd3b2048f59eaaa

you are getting the message about dismissing the logs because LTAPEDEV is set to /dev/null. Although onbar does not use the tape settings from the onconfig, the engine marks each log as backed up when /dev/null is used in LTAPEDEV thus you can not back them up again in onbar or use them in your restore process.

Hi and thanks for your response, 1. That LTAPEDEV is set to null explains the following message in bar_ol_.... File Unable to start the logical log backup: Log backup to device 'nul' not allowed 2010-09-06 16:48:55 4056 4056 C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.10\\\\bin\\\\onbar_d complete, returning 131 (0x83) 2. Does it related with the the error on q backup 'ol_prime/*' command? C:\\\\Tivoli\\\\TSM\\\\baclient>dsmc -optfile=C:\\\\Tivoli\\\\TSM\\\\baclient\\\\dsm_informix.opt IBM Tivoli Storage Manager Command Line Backup/Archive Client Interface Client Version 5, Release 5, Level 3.0 Client date/time: 06-09-2010 16:19:54 (c) Copyright by IBM Corporation and other(s) 1990, 2010. All Rights Reserved. Node Name: PRIME_INFORMIX Session established with server SV-GRTSM_SERVER1: Windows Server Version 5, Release 5, Level 4.0 Server date/time: 06-09-2010 16:21:19 Last access: 06-09-2010 16:16:32 tsm> q backup 'ol_prime/*' ANS1084E No files have previously been backed up for 'ol_prime/*' or the specified file space is invalid for the current operating system.tsm> The command I used is onbar -p -w 3. What I have to define in LTAPEDEV? 4. Do I have to make/define an INCLUDE/EXCLUDE file in tivoli or without the include/exclude file every vital and neccessery informix inforamtion are backued up and there will be no problem with futeure restore? Thanks in advance Sergios

Hi, Is it possible to explain anybody the way that TSM and onbar are related? For example in a imported restore attempt I was not able to restore anything until I ran the q backup .... command (in a different command prompt window). Why that happens? What about in the case that I want to restore older TSM informix backups? How onbar will understand which TSM backups to use for restore? Thanks in advance Sergios