after upgrading to 12.1 log back script not workin

HPUX 11.31 (11iv3) HP BL870c Integrity server IDS 12.10.FC5 Friday I upgraded our ERP with the latest-ish opensource products and Informixto IDS 12.10.FC5 and missed the note about ISM_DATA_POOL and ISM_LOG_POOL being removed. Silly me listened to our ERP that there is nothing extra to the Informix upgrade. It seems the new config items are PSM_DBS_POOL and PSM_LOG_POOL, which got set to the defaults of DBSPOOL and LOGPOOL are in the onconf file. However when our log full scripts runs and tried to do the backup (onbar -b -l) it gets this error 2015-11-28 18:36:56 22642 22640 Using IBM's PSM version 12.10.FC5 as the Storage Manager. XBSA API version is 1.0.3. 2015-11-28 18:36:56 22642 22640 Begin backup logical log 325288. 2015-11-28 18:36:56 22642 22640 The PSM is ready. 2015-11-28 18:36:56 22642 22640 Informix Primary Storage Manager session 251 opened. 2015-11-28 18:36:56 22642 22640 Successfully connected to Storage Manager. 2015-11-28 18:36:56 22642 22640 Error -88035: No Device is available to mount in pool 'LOGPOOL'. 2015-11-28 18:36:56 22642 22640 XBSA Error: (BSACreateObject) Exceeded available resources. 2015-11-28 18:36:56 22642 22640 Informix Primary Storage Manager session 251 closed 2015-11-28 18:36:58 22619 22617 /opt/informix/bin/onbar_d complete, returning 19 (0x13) Which seems to me I missed a step as the LOGPOOL can't be found. Anyone have an idea of what I need to do? A simple ontape -a does work and backup the logs but want to get the automagical script working again. John David Adamski, Sr. Network Specialist Graceland University, 1 University Place, Lamoni, IA 50140 adamski@graceland.edu 641.784.5267

All you need to do is to either create the path that PSM_LOG_POOL points to or change where it points. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Sat, Nov 28, 2015 at 9:09 PM, John Adamski (Work Account) < adamski@graceland.edu> wrote: > HPUX 11.31 (11iv3) > HP BL870c Integrity server > IDS 12.10.FC5 > > Friday I upgraded our ERP with the latest-ish opensource products and > Informixto IDS 12.10.FC5 and missed the note about ISM_DATA_POOL and > ISM_LOG_POOL being removed. Silly me listened to our ERP that there is > nothing > extra to the Informix upgrade. > > It seems the new config items are PSM_DBS_POOL and PSM_LOG_POOL, which got > set > to the defaults of DBSPOOL and LOGPOOL are in the onconf file. > > However when our log full scripts runs and tried to do the backup (onbar -b > -l) it gets this error > > 2015-11-28 18:36:56 22642 22640 Using IBM's PSM version 12.10.FC5 as the > Storage Manager. XBSA API version is 1.0.3. > 2015-11-28 18:36:56 22642 22640 Begin backup logical log 325288. > 2015-11-28 18:36:56 22642 22640 The PSM is ready. > 2015-11-28 18:36:56 22642 22640 Informix Primary Storage Manager session > 251 > opened. > 2015-11-28 18:36:56 22642 22640 Successfully connected to Storage Manager. > 2015-11-28 18:36:56 22642 22640 Error -88035: No Device is available to > mount > in pool 'LOGPOOL'. > 2015-11-28 18:36:56 22642 22640 XBSA Error: (BSACreateObject) Exceeded > available resources. > 2015-11-28 18:36:56 22642 22640 Informix Primary Storage Manager session > 251 > closed > 2015-11-28 18:36:58 22619 22617 /opt/informix/bin/onbar_d complete, > returning > 19 (0x13) > > Which seems to me I missed a step as the LOGPOOL can't be found. Anyone > have > an idea of what I need to do? > > A simple ontape -a does work and backup the logs but want to get the > automagical script working again. > > John David Adamski, Sr. Network Specialist > Graceland University, 1 University Place, Lamoni, IA 50140 > adamski@graceland.edu > 641.784.5267 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a113fe84e0725340525ac7eee

I blaming lack of sleep, as I still don't have something right. I hardcoded BAR_BSALIB_PATH and PSM_CATALOG_PATH to the default locations. I removed the default device entry in onpsm and added new ones for DBSPOOL and LOGPOOL after make sure the directories where there. I then bounced the engine to make sure I came up with all the onconf parameters as I just changed them to be. Did a onbar -b -l to try and do the logs and get the same error. :-( I'm sure the mistake is sticking it's tongue out at me and saying nahnahnahhh at me. informix cars: pwd /opt/informix informix cars: ll /opt/informix/backups total 0 drwxrwx--- 4 informix informix 96 Nov 29 10:42 infx informix cars: ll /opt/informix/backups/infx total 0 drwxrwx--- 2 informix informix 96 Nov 29 10:10 logs drwxrwx--- 2 informix informix 96 Nov 29 10:42 spaces informix cars: onpsm -P list Informix Primary Storage Manager Pool List Pool Id Name 1 DBSPOOL 2 LOGPOOL 3 EXTPOOL informix cars: onpsm -D list Informix Primary Storage Manager Device List Type Prio Block/Size (MB) Pool Name Device Name FILE HIGHEST --/-- DBSPOOL /opt/informix/backups/infx/spaces FILE READ-ONLY --/-- LOGPOOL /opt/informix/backups/infx/logs BAR_ACT_LOG /tmp/bar_act.log BAR_DEBUG_LOG /opt/informix/Logs/bar_dbug.log BAR_DEBUG 0 BAR_MAX_BACKUP 0 BAR_RETRY 1 BAR_NB_XPORT_COUNT 10 BAR_XFER_BUF_SIZE 31 RESTARTABLE_RESTORE off BAR_PROGRESS_FREQ 0 BAR_BSALIB_PATH /opt/informix/lib/libbsapsm.so BACKUP_FILTER RESTORE_FILTER BAR_PERFORMANCE 0 BAR_CKPTSEC_TIMEOUT 15 PSM_CATALOG_PATH /opt/informix/etc/psm PSM_DBS_POOL DBSPOOL PSM_LOG_POOL LOGPOOL informix cars: ll /opt/informix/lib/libbsapsm.so -r-xr-xr-x 1 informix informix 4735264 Mar 9 2015 /opt/informix/lib/libbsapsm.so informix cars: ll /opt/informix/etc/psm total 1352 -rw-rw-r-- 1 informix informix 2048 Nov 29 10:42 device.dat -rw-rw-r-- 1 informix informix 6144 Nov 29 10:42 device.idx -rw-rw-r-- 1 informix informix 1024 Nov 29 10:44 lock.dat -rw-rw-r-- 1 informix informix 2048 Nov 29 10:44 lock.idx -rw-rw-r-- 1 informix informix 635904 Nov 29 10:30 object.dat -rw-rw-r-- 1 informix informix 13312 Nov 29 10:30 object.idx -rw-rw-r-- 1 informix informix 6144 Nov 29 10:10 object_detail.dat -rw-rw-r-- 1 informix informix 7168 Nov 29 10:10 object_detail.idx -rw-rw-r-- 1 informix informix 0 Nov 27 08:41 pool.dat -rw-rw-r-- 1 informix informix 4096 Nov 27 08:41 pool.idx -rw-rw-r-- 1 informix informix 1024 Nov 29 10:44 serial.dat -rw-rw-r-- 1 informix informix 2048 Nov 29 10:44 serial.idx -rw-rw-r-- 1 informix informix 1024 Nov 29 10:44 session.dat -rw-rw-r-- 1 informix informix 3072 Nov 29 10:44 session.idx -rw-rw-r-- 1 informix informix 2048 Nov 29 10:42 volume.dat -rw-rw-r-- 1 informix informix 5120 Nov 29 10:42 volume.idx 2015-11-29 10:53:01 9108 9106 /opt/informix/bin/onbar_d -b -l 2015-11-29 10:53:01 9108 9106 Using IBM's PSM version 12.10.FC5 as the Storage Manager. XBSA API version is 1.0.3. 2015-11-29 10:53:02 9108 9106 Begin backup logical log 325421. 2015-11-29 10:53:02 9108 9106 The PSM is ready. 2015-11-29 10:53:02 9108 9106 Informix Primary Storage Manager session 384 opened. 2015-11-29 10:53:02 9108 9106 Successfully connected to Storage Manager. 2015-11-29 10:53:02 9108 9106 Error -88035: No Device is available to mount in pool 'LOGPOOL'. 2015-11-29 10:53:02 9108 9106 XBSA Error: (BSACreateObject) Exceeded available resources. 2015-11-29 10:53:02 9108 9106 Informix Primary Storage Manager session 384 closed 2015-11-29 10:53:07 9108 9106 /opt/informix/bin/onbar_d complete, returning 19 (0x13) -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel Sent: Sunday, November 29, 2015 5:48 AM To: ids@iiug.org Subject: Re: after upgrading to 12.1 log back script no.... [36128] All you need to do is to either create the path that PSM_LOG_POOL points to or change where it points. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Sat, Nov 28, 2015 at 9:09 PM, John Adamski (Work Account) < adamski@graceland.edu> wrote: > HPUX 11.31 (11iv3) > HP BL870c Integrity server > IDS 12.10.FC5 > > Friday I upgraded our ERP with the latest-ish opensource products and > Informixto IDS 12.10.FC5 and missed the note about ISM_DATA_POOL and > ISM_LOG_POOL being removed. Silly me listened to our ERP that there is > nothing extra to the Informix upgrade. > > It seems the new config items are PSM_DBS_POOL and PSM_LOG_POOL, which > got set to the defaults of DBSPOOL and LOGPOOL are in the onconf file. > > However when our log full scripts runs and tried to do the backup > (onbar -b > -l) it gets this error > > 2015-11-28 18:36:56 22642 22640 Using IBM's PSM version 12.10.FC5 as > the Storage Manager. XBSA API version is 1.0.3. > 2015-11-28 18:36:56 22642 22640 Begin backup logical log 325288. > 2015-11-28 18:36:56 22642 22640 The PSM is ready. > 2015-11-28 18:36:56 22642 22640 Informix Primary Storage Manager > session > 251 > opened. > 2015-11-28 18:36:56 22642 22640 Successfully connected to Storage Manager. > 2015-11-28 18:36:56 22642 22640 Error -88035: No Device is available > to mount in pool 'LOGPOOL'. > 2015-11-28 18:36:56 22642 22640 XBSA Error: (BSACreateObject) Exceeded > available resources. > 2015-11-28 18:36:56 22642 22640 Informix Primary Storage Manager > session > 251 > closed > 2015-11-28 18:36:58 22619 22617 /opt/informix/bin/onbar_d complete, > returning > 19 (0x13) > > Which seems to me I missed a step as the LOGPOOL can't be found. > Anyone have an idea of what I need to do? > > A simple ontape -a does work and backup the logs but want to get the > automagical script working again. > > John David Adamski, Sr. Network Specialist Graceland University, 1 > University Place, Lamoni, IA 50140 adamski@graceland.edu > 641.784.5267 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a113fe84e0725340525ac7eee ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Thanks to Petr he got it working it seems my onpsm command when I setup the LOGPOOL must have been wrong or something as the pool was READ-ONLY (no idea why I didn't see that). Did a onpsm -D update /opt/informix/backups/infx/logs -g LOGPOOL -p HIGHEST and poof it started working. onpsm -D list Password for adamski: Informix Primary Storage Manager Device List Type Prio Block/Size (MB) Pool Name Device Name FILE HIGHEST --/-- DBSPOOL /opt/informix/backups/infx/spaces FILE HIGHEST --/-- LOGPOOL /opt/informix/backups/infx/logs Original command used: onpsm -D add /opt/informix/backups/infx/logs -g LOGPOOL -p HIGHEST -t FILE seems this should have worked. Well thanks all for the help. John -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of John Adamski (Work Account) Sent: Sunday, November 29, 2015 11:07 AM To: ids@iiug.org Subject: RE: after upgrading to 12.1 log back script no.... [36129] I blaming lack of sleep, as I still don't have something right. I hardcoded BAR_BSALIB_PATH and PSM_CATALOG_PATH to the default locations. I removed the default device entry in onpsm and added new ones for DBSPOOL and LOGPOOL after make sure the directories where there. I then bounced the engine to make sure I came up with all the onconf parameters as I just changed them to be. Did a onbar -b -l to try and do the logs and get the same error. :-( I'm sure the mistake is sticking it's tongue out at me and saying nahnahnahhh at me. informix cars: pwd /opt/informix informix cars: ll /opt/informix/backups total 0 drwxrwx--- 4 informix informix 96 Nov 29 10:42 infx informix cars: ll /opt/informix/backups/infx total 0 drwxrwx--- 2 informix informix 96 Nov 29 10:10 logs drwxrwx--- 2 informix informix 96 Nov 29 10:42 spaces informix cars: onpsm -P list Informix Primary Storage Manager Pool List Pool Id Name 1 DBSPOOL 2 LOGPOOL 3 EXTPOOL informix cars: onpsm -D list Informix Primary Storage Manager Device List Type Prio Block/Size (MB) Pool Name Device Name FILE HIGHEST --/-- DBSPOOL /opt/informix/backups/infx/spaces FILE READ-ONLY --/-- LOGPOOL /opt/informix/backups/infx/logs BAR_ACT_LOG /tmp/bar_act.log BAR_DEBUG_LOG /opt/informix/Logs/bar_dbug.log BAR_DEBUG 0 BAR_MAX_BACKUP 0 BAR_RETRY 1 BAR_NB_XPORT_COUNT 10 BAR_XFER_BUF_SIZE 31 RESTARTABLE_RESTORE off BAR_PROGRESS_FREQ 0 BAR_BSALIB_PATH /opt/informix/lib/libbsapsm.so BACKUP_FILTER RESTORE_FILTER BAR_PERFORMANCE 0 BAR_CKPTSEC_TIMEOUT 15 PSM_CATALOG_PATH /opt/informix/etc/psm PSM_DBS_POOL DBSPOOL PSM_LOG_POOL LOGPOOL informix cars: ll /opt/informix/lib/libbsapsm.so -r-xr-xr-x 1 informix informix 4735264 Mar 9 2015 /opt/informix/lib/libbsapsm.so informix cars: ll /opt/informix/etc/psm total 1352 -rw-rw-r-- 1 informix informix 2048 Nov 29 10:42 device.dat -rw-rw-r-- 1 informix informix 6144 Nov 29 10:42 device.idx -rw-rw-r-- 1 informix informix 1024 Nov 29 10:44 lock.dat -rw-rw-r-- 1 informix informix 2048 Nov 29 10:44 lock.idx -rw-rw-r-- 1 informix informix 635904 Nov 29 10:30 object.dat -rw-rw-r-- 1 informix informix 13312 Nov 29 10:30 object.idx -rw-rw-r-- 1 informix informix 6144 Nov 29 10:10 object_detail.dat -rw-rw-r-- 1 informix informix 7168 Nov 29 10:10 object_detail.idx -rw-rw-r-- 1 informix informix 0 Nov 27 08:41 pool.dat -rw-rw-r-- 1 informix informix 4096 Nov 27 08:41 pool.idx -rw-rw-r-- 1 informix informix 1024 Nov 29 10:44 serial.dat -rw-rw-r-- 1 informix informix 2048 Nov 29 10:44 serial.idx -rw-rw-r-- 1 informix informix 1024 Nov 29 10:44 session.dat -rw-rw-r-- 1 informix informix 3072 Nov 29 10:44 session.idx -rw-rw-r-- 1 informix informix 2048 Nov 29 10:42 volume.dat -rw-rw-r-- 1 informix informix 5120 Nov 29 10:42 volume.idx 2015-11-29 10:53:01 9108 9106 /opt/informix/bin/onbar_d -b -l 2015-11-29 10:53:01 9108 9106 Using IBM's PSM version 12.10.FC5 as the Storage Manager. XBSA API version is 1.0.3. 2015-11-29 10:53:02 9108 9106 Begin backup logical log 325421. 2015-11-29 10:53:02 9108 9106 The PSM is ready. 2015-11-29 10:53:02 9108 9106 Informix Primary Storage Manager session 384 opened. 2015-11-29 10:53:02 9108 9106 Successfully connected to Storage Manager. 2015-11-29 10:53:02 9108 9106 Error -88035: No Device is available to mount in pool 'LOGPOOL'. 2015-11-29 10:53:02 9108 9106 XBSA Error: (BSACreateObject) Exceeded available resources. 2015-11-29 10:53:02 9108 9106 Informix Primary Storage Manager session 384 closed 2015-11-29 10:53:07 9108 9106 /opt/informix/bin/onbar_d complete, returning 19 (0x13) -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel Sent: Sunday, November 29, 2015 5:48 AM To: ids@iiug.org Subject: Re: after upgrading to 12.1 log back script no.... [36128] All you need to do is to either create the path that PSM_LOG_POOL points to or change where it points. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Sat, Nov 28, 2015 at 9:09 PM, John Adamski (Work Account) < adamski@graceland.edu> wrote: > HPUX 11.31 (11iv3) > HP BL870c Integrity server > IDS 12.10.FC5 > > Friday I upgraded our ERP with the latest-ish opensource products and > Informixto IDS 12.10.FC5 and missed the note about ISM_DATA_POOL and > ISM_LOG_POOL being removed. Silly me listened to our ERP that there is > nothing extra to the Informix upgrade. > > It seems the new config items are PSM_DBS_POOL and PSM_LOG_POOL, which > got set to the defaults of DBSPOOL and LOGPOOL are in the onconf file. > > However when our log full scripts runs and tried to do the backup > (onbar -b > -l) it gets this error > > 2015-11-28 18:36:56 22642 22640 Using IBM's PSM version 12.10.FC5 as > the Storage Manager. XBSA API version is 1.0.3. > 2015-11-28 18:36:56 22642 22640 Begin backup logical log 325288. > 2015-11-28 18:36:56 22642 22640 The PSM is ready. > 2015-11-28 18:36:56 22642 22640 Informix Primary Storage Manager > session > 251 > opened. > 2015-11-28 18:36:56 22642 22640 Successfully connected to Storage Manager. > 2015-11-28 18:36:56 22642 22640 Error -88035: No Device is available > to mount in pool 'LOGPOOL'. > 2015-11-28 18:36:56 22642 22640 XBSA Error: (BSACreateObject) Exceeded > available resources. > 2015-11-28 18:36:56 22642 22640 Informix Primary Storage Manager > session > 251 > closed > 2015-11-28 18:36:58 22619 22617 /opt/informix/bin/onbar_d complete, > returning > 19 (0x13) > > Which seems to me I missed a step as the LOGPOOL can't be found. > Anyone have an idea of what I need to do? > > A simple ontape -a does work and backup the logs but want to get the@@NL@