Join IIUG
 for   
 

Informix News
18 Nov 13 - ZDNet - Top 20 mobile skills in demand... Read
09 Sep 13 - telecompaper - Shaspa and Tatung have shown a new smart home platform at Ifa in Berlin. Powered by the IBM Informix software... Read
06 Sep 13 - IBM data magazine - Mission Accomplished - Miami, Florida will be the backdrop for the 2014 IIUG Informix Conference... Read
01 Feb 13 - IBM Data Magazine - Are your database backups safe? Lester Knutsen (IBM Champion) writes about database back up safety using "archecker"... Read
14 Nov 12 - IBM - IBM's Big Data For Smart Grid Goes Live In Texas... Read
3 Oct 12 - The Financial - IBM and TransWorks Collaborate to Help Louisiana-Pacific Corporation Achieve Supply Chain Efficiency... Read
28 Aug 12 - techCLOUD9 - Splunk kicks up a SaaS Storm... Read
10 Aug 12 - businessCLOUD9 - Is this the other half of Cloud monitoring?... Read
3 Aug 12 - IBM data management - Supercharging the data warehouse while keeping costs down IBM Informix Warehouse Accelerator (IWA) delivers superior performance for in-memory analytics processing... Read
2 Aug 12 - channelbiz - Oninit Group launches Pay Per Pulse cloud-based service... Read
28 May 12 - Bloor - David Norfolk on the recent Informix benchmark "pretty impressive results"... Read
23 May 12 - DBTA - Informix Genero: A Way to Modernize Informix 4GL Applications... Read
9 Apr 12 - Mastering Data Management - Upping the Informix Ante: Advanced Data Tools... Read
22 Mar 12 - developerWorks - Optimizing Informix database access... Read
14 Mar 12 - BernieSpang.com - International Informix User Group set to meet in San Diego... Read
1 Mar 12 - IBM Data Management - IIUG Heads West for 2012 - Get ready for sun and sand in San Diego... Read
1 Mar 12 - IBM Data Management - Running Informix on Solid-State Drives.Speed Up Database Access... Read
26 Feb 12 - BernieSpan.com - Better results, lower cost for a broad set of new IBM clients and partners... Read
24 Feb 12 - developerWorks - Informix Warehouse Accelerator: Continuous Acceleration during Data Refresh... Read
6 Feb 12 - PRLOG - Informix port delivers unlimited database scalability for popular SaaS application ... Read
2 Feb 12 - developerWorks - Loading data with the IBM Informix TimeSeries Plug-in for Data Studio... Read
1 Feb 12 - developerWorks - 100 Tech Tips, #47: Log-in to Fix Central... Read
13 Jan 12 - MC Press online - Informix Dynamic Server Entices New Users with Free Production Edition ... Read
11 Jan 12 - Computerworld - Ecologic Analytics and Landis+Gyr -- Suitors Decide to Tie the Knot... Read
9 Jan 12 - planetIDS.com - DNS impact on Informix / Impacto do DNS no Informix... Read
8 Sep 11 - TMCnet.com - IBM Offers Database Solution to Enable Smart Meter Data Capture... Read
1 Aug 11 - IBM Data Management Magazine - IIUG user view: Happy 10th anniversary to IBM and Informix... Read
8 Jul 11 - Database Trends and Applications - Managing Time Series Data with Informix... Read
31 May 11 - Smart Grid - The meter data management pitfall utilities are overlooking... Read
27 May 11 - IBM Data Management Magazine - IIUG user view: Big data, big time ( Series data, warehouse acceleration, and 4GLs )... Read
16 May 11 - Business Wire - HiT Software Announces DBMoto for Enterprise Integration, Adds Informix. Log-based Change Data Capture... Read
21 Mar 11 - Yahoo! Finance - IBM and Cable&Wireless Worldwide Announce UK Smart Energy Cloud... Read
14 Mar 11 - MarketWatch - Fuzzy Logix and IBM Unveil In-Database Analytics for IBM Informix... Read
11 Mar 11 - InvestorPlace - It's Time to Give IBM Props: How many tech stocks are up 53% since the dot-com boom?... Read
9 Mar 11 - DBTA - Database Administration and the Goal of Diminishing Downtime... Read
2 Feb 11 - DBTAs - Informix 11.7 Flexible Grid Provides a Different Way of Looking at Database Servers... Read
27 Jan 11 - exactsolutions - Exact to Add Informix Support to Database Replay, SQL Monitoring Solutions... Read
25 Jan 11 - PR Newswire - Bank of China in the UK Works With IBM to Become a Smarter, Greener Bank... Read
12 Oct 10 - Database Trends and Applications - Informix 11.7: The Beginning of the Next Decade of IBM Informix... Read
20 Sep 10 - planetIDS.com - ITG analyst paper: Cost/Benefit case for IBM Informix as compared to Microsoft SQL Server... Read
20 Jul 10 - IBM Announcements - IBM Informix Choice Edition V11.50 helps deploy low-cost scalable and reliable solutions for Apple Macintosh and Microsoft Windows... Read
20 Jul 10 - IBM Announcements - Software withdrawal: Elite Support for Informix Ultimate-C Edition... Read
24 May 10 - eWeek Europe - IBM Supplies Database Tech For EU Smart Grid... Read
23 May 10 - SiliconIndia - IBM's smart metering system allows wise use of energy... Read
21 May 10 - CNET - IBM to help people monitor energy use... Read
20 May 10 - ebiz - IBM Teams With Hildebrand To Bring Smart Metering To Homes Across Britain... Read
19 May 10 - The New Blog Times - Misurare il consumo energetico: DEHEMS è pronto... Read
19 May 10 - ZDNet - IBM software in your home? Pact enables five-city smart meter pilot in Europe... Read
17 March 10 - ZDNet (blog) David Morgenstern - TCO: New research finds Macs in the enterprise easier, cheaper to manage than... Read
17 March 2010 - Virtualization Review - ...key components of Big Blue's platform to the commercial cloud such as its WebSphere suite of application ser vers and its DB2 and Informix databases... Read
10 February 2010 - The Wall Street Journal - International Business Machines is expanding an initiative to win over students and professors on its products. How do they lure the college crowd?... Read

End of Support Dates
IDS 11.10 - 30 Sep 2012
Subscribe to notifications

IIUG on Facebook IIUG on Twitter

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum

Informix backup fails.

Posted By: SACHIN SABLE
Date: Thursday, 7 February 2008, at 3:44 a.m.

Hi,

I am trying to take backup of my Informix database using the Onbar but the backup fails, I cheked the bar_act.log file I found the following :-

BACKUP & VERIFICATION
=====================
For IBM Informix Dynamic Server:

-b [-L <level>] [-w | -f <filename> | <spaces>] [-O]

-b -F

-b -l [-c | -C | -s] [-O]

-v [-w] [-p] [-t <time>] [-f <filename> | <spaces>]

-b backup

-c backup current logical log

-C continuous logical log backup

-f pathname of file containing list of storage spaces

-F fake backup

-l backup full logical logs (no spaces)

-L backup level: 0, 1, or 2, defaults to 0

-O override internal error checks - enforce policy strictly

-p backup spaces only (no logs)

-w whole system backup

-s salvage logs

-v verify consistency of most recent backups

<spaces> list of storage spaces to backup
2008-01-10 01:41:35 4888 4888 onbar usage

RESTORE
========
For IBM Informix Dynamic Server:

-r [-e] [-O] [-f <filename> | <spaces>]

-r [-e] [-t <time> | -n <log>] [-O]

-r -p [-e] [-t <time>] [-O] [-f <filename> | <spaces>]

-r -l [-t <time> | -n <log>]

-r -w [-e] [[-p] [ -t <time>] | -n <log>] [-O]

-RESTART

-r -rename -f <filename> [-w] [-p] [-t <time> | -n <log>]

[-f <filename> | <spaces>]

-r {-rename -p <old path> -o <old offset> -n <new path>

-o <new offset>...} [-w] [-p] [-t <time> | -n <log>]

[-f <filename> | <spaces>]

-e external restore

-f pathname of file containing list of storage spaces

-l logical log only restore (no spaces)

-n last logical log to restore

-O override internal error checks - enforce policy strictly

-p physical only restore (no logs)

-r restore

-t point in time to stop restore

-w whole system to restore

-RESTART restart an interrupted restore

<spaces> list of storage spaces to restore

-rename rename chunks during cold restore

With -rename option:

-rename -f <filename> pathname of file containing list of mapped

chunk pathnames and offsets

-p old pathname of chunk

-o old offset of chunk

-n new pathname of chunk

-o new offset of chunk
2008-01-10 01:41:35 4888 4888 d:\informix\prd\bin\onbar_d complete, returning 149 (0x95)
2008-01-10 01:59:03 792 792 Warning: BAR_TIMEOUT Storage Manager Progress may be stalled.
2008-01-10 02:29:03 792 792 Warning: BAR_TIMEOUT Storage Manager Progress may be stalled.
2008-01-10 02:59:03 792 792 Warning: BAR_TIMEOUT Storage Manager Progress may be stalled.
2008-01-10 03:29:03 792 792 Warning: BAR_TIMEOUT Storage Manager Progress may be stalled.
2008-01-10 03:59:03 792 792 Warning: BAR_TIMEOUT Storage Manager Progress may be stalled.
2008-01-10 04:29:03 792 792 Warning: BAR_TIMEOUT Storage Manager Progress may be stalled.
2008-01-10 04:59:03 792 792 Warning: BAR_TIMEOUT Storage Manager Progress may be stalled.
2008-01-10 05:29:03 792 792 Warning: BAR_TIMEOUT Storage Manager Progress may be stalled.
2008-01-10 05:59:03 792 792 Warning: BAR_TIMEOUT Storage Manager Progress may be stalled.
2008-01-10 06:29:03 792 792 Warning: BAR_TIMEOUT Storage Manager Progress may be stalled.
2008-01-10 06:59:03 792 792 Warning: BAR_TIMEOUT Storage Manager Progress may be stalled.
2008-01-10 07:29:03 792 792 Warning: BAR_TIMEOUT Storage Manager Progress may be stalled.
2008-01-10 07:59:03 792 792 Warning: BAR_TIMEOUT Storage Manager Progress may be stalled.
2008-01-10 08:29:03 792 792 Warning: BAR_TIMEOUT Storage Manager Progress may be stalled.
2008-01-10 08:59:03 792 792 Warning: BAR_TIMEOUT Storage Manager Progress may be stalled.
2008-01-10 09:29:03 792 792 Warning: BAR_TIMEOUT Storage Manager Progress may be stalled.
2008-01-11 13:19:18 4420 4420 d:\informix\prd\bin\onbar_d -b -L 0
2008-01-11 13:19:18 4420 4420 BAR_XFER_BUF_SIZE exceeded maximum allowed limit. Changing buffer size to 61440.
2008-01-11 13:19:20 4420 4420 Begin level 0 backup rootdbs.
2008-01-11 13:19:23 4420 4420 Successfully connected to Storage Manager.
2008-01-11 13:31:18 4420 4420 Warning: BAR_TIMEOUT Storage Manager Progress may be stalled.
2008-01-11 14:01:18 4420 4420 Warning: BAR_TIMEOUT Storage Manager Progress may be stalled.
2008-01-11 14:31:18 4420 4420 Warning: BAR_TIMEOUT Storage Manager Progress may be stalled.
2008-01-11 15:01:18 4420 4420 Warning: BAR_TIMEOUT Storage Manager Progress may be stalled.
2008-01-11 15:31:18 4420 4420 Warning: BAR_TIMEOUT Storage Manager Progress may be stalled.
2008-01-11 16:01:18 4420 4420 Warning: BAR_TIMEOUT Storage Manager Progress may be stalled.
2008-01-11 16:31:18 4420 4420 Warning: BAR_TIMEOUT Storage Manager Progress may be stalled.
2008-01-11 16:55:43 4420 4420 Completed level 0 backup rootdbs (Storage Manager copy ID: 37572 0).
2008-01-11 16:55:43 4480 4420 onbar_d -b logdbs
2008-01-11 16:55:43 4480 4420 BAR_XFER_BUF_SIZE exceeded maximum allowed limit. Changing buffer size to 61440.
2008-01-11 16:55:43 552 4420 onbar_d -b physdbs
2008-01-11 16:55:43 4232 4420 onbar_d -b psapclu
2008-01-11 16:55:43 552 4420 BAR_XFER_BUF_SIZE exceeded maximum allowed limit. Changing buffer size to 61440.
2008-01-11 16:55:43 4232 4420 BAR_XFER_BUF_SIZE exceeded maximum allowed limit. Changing buffer size to 61440.
2008-01-11 16:55:44 4340 4420 onbar_d -b psapel620
2008-01-11 16:55:44 5068 4420 onbar_d -b psapbtab
2008-01-11 16:55:44 4340 4420 BAR_XFER_BUF_SIZE exceeded maximum allowed limit. Changing buffer size to 61440.
2008-01-11 16:55:44 5068 4420 BAR_XFER_BUF_SIZE exceeded maximum allowed limit. Changing buffer size to 61440.
2008-01-11 16:55:44 4552 4420 onbar_d -b psappool
2008-01-11 16:55:44 4552 4420 BAR_XFER_BUF_SIZE exceeded maximum allowed limit. Changing buffer size to 61440.
2008-01-11 16:55:44 900 4420 onbar_d -b psapprot
2008-01-11 16:55:44 3528 4420 onbar_d -b psapsource
2008-01-11 16:55:44 900 4420 BAR_XFER_BUF_SIZE exceeded maximum allowed limit. Changing buffer size to 61440.
2008-01-11 16:55:44 3528 4420 BAR_XFER_BUF_SIZE exceeded maximum allowed limit. Changing buffer size to 61440.
2008-01-11 16:55:44 4184 4420 onbar_d -b psapes620
2008-01-11 16:55:44 4632 4420 onbar_d -b psapload
2008-01-11 16:55:44 4656 4420 onbar_d -b psapel40b
2008-01-11 16:55:44 4248 4420 onbar_d -b psapes40b
2008-01-11 16:55:44 4564 4420 onbar_d -b psapuser1
2008-01-11 16:55:44 4184 4420 BAR_XFER_BUF_SIZE exceeded maximum allowed limit. Changing buffer size to 61440.
2008-01-11 16:55:44 4632 4420 BAR_XFER_BUF_SIZE exceeded maximum allowed limit. Changing buffer size to 61440.
2008-01-11 16:55:44 1528 4420 onbar_d -b psapstab
2008-01-11 16:55:44 4248 4420 BAR_XFER_BUF_SIZE exceeded maximum allowed limit. Changing buffer size to 61440.
2008-01-11 16:55:44 4656 4420 BAR_XFER_BUF_SIZE exceeded maximum allowed limit. Changing buffer size to 61440.
2008-01-11 16:55:44 4564 4420 BAR_XFER_BUF_SIZE exceeded maximum allowed limit. Changing buffer size to 61440.
2008-01-11 16:55:44 1528 4420 BAR_XFER_BUF_SIZE exceeded maximum allowed limit. Changing buffer size to 61440.
2008-01-11 16:55:44 3308 4420 onbar_d -b psapdocu
2008-01-11 16:55:44 3308 4420 BAR_XFER_BUF_SIZE exceeded maximum allowed limit. Changing buffer size to 61440.
2008-01-11 16:55:44 4620 4420 onbar_d -b psapddic
2008-01-11 16:55:44 4620 4420 BAR_XFER_BUF_SIZE exceeded maximum allowed limit. Changing buffer size to 61440.
2008-01-11 16:55:56 4480 4420 Begin level 0 backup logdbs.
2008-01-11 16:55:56 4232 4420 Begin level 0 backup psapclu.
2008-01-11 16:55:56 552 4420 Begin level 0 backup physdbs.
2008-01-11 16:55:56 4248 4420 Begin level 0 backup psapes40b.
2008-01-11 16:55:56 4656 4420 Begin level 0 backup psapel40b.
2008-01-11 16:55:56 4564 4420 Begin level 0 backup psapuser1.
2008-01-11 16:55:56 4632 4420 Begin level 0 backup psapload.
2008-01-11 16:55:56 4340 4420 Begin level 0 backup psapel620.
2008-01-11 16:55:56 3528 4420 Begin level 0 backup psapsource.
2008-01-11 16:55:56 3308 4420 Begin level 0 backup psapdocu.
2008-01-11 16:55:56 900 4420 Begin level 0 backup psapprot.
2008-01-11 16:55:56 4184 4420 Begin level 0 backup psapes620.
2008-01-11 16:55:56 5068 4420 Begin level 0 backup psapbtab.
2008-01-11 16:55:56 1528 4420 Begin level 0 backup psapstab.
2008-01-11 16:55:56 4620 4420 Begin level 0 backup psapddic.
2008-01-11 16:55:56 4552 4420 Begin level 0 backup psappool.
2008-01-11 16:55:59 4232 4420 Successfully connected to Storage Manager.
2008-01-11 16:56:01 4480 4420 Successfully connected to Storage Manager.
2008-01-11 16:56:03 552 4420 Successfully connected to Storage Manager.
2008-01-11 16:56:06 4248 4420 Successfully connected to Storage Manager.
2008-01-11 16:56:08 4656 4420 Successfully connected to Storage Manager.
2008-01-11 16:56:15 4564 4420 Successfully connected to Storage Manager.
2008-01-11 16:56:17 4632 4420 Successfully connected to Storage Manager.
2008-01-11 16:56:21 4184 4420 Successfully connected to Storage Manager.
2008-01-11 16:56:24 900 4420 Successfully connected to Storage Manager.
2008-01-11 16:56:30 3308 4420 Successfully connected to Storage Manager.
2008-01-11 16:56:33 3528 4420 Successfully connected to Storage Manager.
2008-01-11 16:56:35 4552 4420 Successfully connected to Storage Manager.
2008-01-11 16:56:37 5068 4420 Successfully connected to Storage Manager.
2008-01-11 16:56:40 1528 4420 Successfully connected to Storage Manager.
2008-01-11 16:56:42 4620 4420 Successfully connected to Storage Manager.
2008-01-11 16:56:44 4340 4420 Successfully connected to Storage Manager.
2008-01-11 17:07:43 4480 4420 Warning: BAR_TIMEOUT Storage Manager Progress may be stalled.
2008-01-11 17:07:43 552 4420 Warning: BAR_TIMEOUT Storage Manager Progress may be stalled.
2008-01-11 17:07:43 4232 4420 Warning: BAR_TIMEOUT Storage Manager Progress may be stalled.
2008-01-11 17:07:44 4340 4420 Warning: BAR_TIMEOUT Storage Manager Progress may be stalled.
2008-01-11 17:07:44 5068 4420 Warning: BAR_TIMEOUT Storage Manager Progress may be stalled.
2008-01-11 17:07:44 4552 4420 Warning: BAR_TIMEOUT Storage Manager Progress may be stalled.
2008-01-11 17:07:44 900 4420 Warning: BAR_TIMEOUT Storage Manager Progress may be stalled.
2008-01-11 17:07:44 3528 4420 Warning: BAR_TIMEOUT Storage Manager Progress may be stalled.
2008-01-11 17:07:44 4656 4420 Warning: BAR_TIMEOUT Storage Manager Progress may be stalled.
2008-01-11 17:07:44 4184 4420 Warning: BAR_TIMEOUT Storage Manager Progress may be stalled.
2008-01-11 17:07:44 4248 4420 Warning: BAR_TIMEOUT Storage Manager Progress may be stalled.
2008-01-11 17:07:44 4632 4420 Warning: BAR_TIMEOUT Storage Manager Progress may be stalled.
2008-01-11 17:07:44 4564 4420 Warning: BAR_TIMEOUT Storage Manager Progress may be stalled.
2008-01-11 17:07:44 1528 4420 Warning: BAR_TIMEOUT Storage Manager Progress may be stalled.
2008-01-11 17:07:44 3308 4420 Warning: BAR_TIMEOUT Storage Manager Progress may be stalled.
2008-01-11 17:07:44 4620 4420 Warning: BAR_TIMEOUT Storage Manager Progress may be stalled.
2008-01-11 17:09:30 4248 4420 Completed level 0 backup psapes40b (Storage Manager copy ID: 37574 0).
2008-01-11 17:09:30 4564 4420 Completed level 0 backup psapuser1 (Storage Manager copy ID: 37576 0).
2008-01-11 17:09:30 4656 4420 Completed level 0 backup psapel40b (Storage Manager copy ID: 37575 0).
2008-01-11 17:09:31 4248 4420 onbar_d complete, returning 0 (0x00)
2008-01-11 17:09:31 4564 4420 onbar_d complete, returning 0 (0x00)
2008-01-11 17:09:31 4656 4420 onbar_d complete, returning 0 (0x00)
2008-01-11 17:11:23 4232 4420 Completed level 0 backup psapclu (Storage Manager copy ID: 37573 0).
2008-01-11 17:11:23 552 4420 Completed level 0 backup physdbs (Storage Manager copy ID: 37577 0).
2008-01-11 17:11:23 4232 4420 onbar_d complete, returning 0 (0x00)
2008-01-11 17:11:23 552 4420 onbar_d complete, returning 0 (0x00)
2008-01-11 17:11:32 3308 4420 Completed level 0 backup psapdocu (Storage Manager copy ID: 37579 0).
2008-01-11 17:11:32 3308 4420 onbar_d complete, returning 0 (0x00)
2008-01-11 17:12:56 4632 4420 Completed level 0 backup psapload (Storage Manager copy ID: 37580 0).
2008-01-11 17:12:56 4632 4420 onbar_d complete, returning 0 (0x00)
2008-01-11 17:13:42 3528 4420 Completed level 0 backup psapsource (Storage Manager copy ID: 37582 0).
2008-01-11 17:13:42 3528 4420 onbar_d complete, returning 0 (0x00)
2008-01-11 17:14:21 900 4420 Completed level 0 backup psapprot (Storage Manager copy ID: 37583 0).
2008-01-11 17:14:21 900 4420 onbar_d complete, returning 0 (0x00)
2008-01-11 17:17:06 4620 4420 Completed level 0 backup psapddic (Storage Manager copy ID: 37581 0).
2008-01-11 17:17:06 4620 4420 onbar_d complete, returning 0 (0x00)
2008-01-11 17:25:31 1528 4420 Completed level 0 backup psapstab (Storage Manager copy ID: 37586 0).
2008-01-11 17:25:31 1528 4420 onbar_d complete, returning 0 (0x00)
2008-01-11 17:26:44 4552 4420 Completed level 0 backup psappool (Storage Manager copy ID: 37587 0).
2008-01-11 17:26:45 4552 4420 onbar_d complete, returning 0 (0x00)
2008-01-11 17:27:15 4480 4420 Completed level 0 backup logdbs (Storage Manager copy ID: 37591 0).
2008-01-11 17:27:15 4480 4420 onbar_d complete, returning 0 (0x00)
2008-01-11 17:28:45 4340 4420 Completed level 0 backup psapel620 (Storage Manager copy ID: 37590 0).
2008-01-11 17:28:46 4340 4420 onbar_d complete, returning 0 (0x00)
2008-01-11 17:30:38 5068 4420 Completed level 0 backup psapbtab (Storage Manager copy ID: 37584 0).

2008-01-11 17:30:38 5068 4420 onbar_d complete, returning 0 (0x00)
2008-01-11 17:34:28 4184 4420 Completed level 0 backup psapes620 (Storage Manager copy ID: 37578 0).

2008-01-11 16:55:44 4184 4420 BAR_XFER_BUF_SIZE exceeded maximum allowed limit. Changing buffer size to 61440.
2008-01-11 17:07:44 3528 4420 Warning: BAR_TIMEOUT Storage Manager Progress may be stalled.2008-01-11 17:34:29 4184 4420 onbar_d complete, returning 0 (0x00)
2008-01-11 17:34:29 4420 4420 Unable to start the logical log backup: Log backup to device 'nul' not allowed
2008-01-11 17:34:35 4420 4420 d:\informix\prd\bin\onbar_d complete, returning 131 (0x83)

I change the parameter in onconfig file LTAPEDEV From NUL To \\.\Tape0 as I am taking a backup on Tape. But after changing this I am not able to start the database.
Server details are: - Os Windows 2000 Sap Kernel 6.40,IDS 9.40

Pl guide me to resolve this issue.

Thanks & Regards,
Sachin

Messages In This Thread

  • Informix backup fails.
    SACHIN SABLE -- Thursday, 7 February 2008, at 3:44 a.m.

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum is maintained by Administrator with WebBBS 5.12.