Video Screencast Help
Symantec Appoints Michael A. Brown CEO. Learn more.

Informix DB backups failing with 6..any suggestions ?

Created: 09 Dec 2012 | 3 comments

Comments 3 CommentsJump to latest comment

Nagalla's picture

you would need to provide the detail info,

what is the netbackup version /OS?

client version /and data base agent version ?

detaill status of the failed job?

any log finding in dbclient ?

 

Marianne's picture

Status 6 is a generic database failure.

You need to check the backup script output as well as NBU logs.
Find where Informix writes log file by locating BAR_ACT_LOG entry in the $INFORMIXDIR/etc/ONCONFIG file.

Check that the following folders exist on the client:

/usr/openv/netbackup/logs/user_ops/dbext/logs
/usr/openv/netbackup/logs/infxbsa
Their permissions should be 777.
 
All of the above (and LOTS more) are documented in NBU for Informix Admin Guide.
Use 'Handy NBU Links' in my signature to locate manuals for your NBU version.
 
Read through the config section of the manual to verify correct configuration and then the Troubleshooting section.

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

Dyneshia's picture

With such little information to go by... here is a compelte list of what we would need :

1.  Set VERBOSE = 9 in all bp.conf files (master, media, client, and client user $HOME/bp.conf)
2.  Stop / restart NB
3.  Set "BAR_DEBUG 9" and "BAR_DEBUG_LOG /tmp/bar_dbug.log" in the $INFORMIXDIR/etc/$ONCONFIG file
4.  Stop / restart Informix
5.  Attempt the restore
6.  Gather logs and other appropriate information (i.e. directory listings, bp.conf file contents)
7.  Tar, gzip, and ftp all this information to me

All log directories should be created under /usr/openv/netbackup/logs with 777 permissions.

From the Informix backup client:

	/usr/openv/netbackup/logs/bphdb
	/usr/openv/netbackup/logs/infxbsa
	/usr/openv/netbackup/logs/bpcd
	BAR_ACT_LOG from the time period of the backup
	BAR_DEBUG_LOG from the time period of the backup
	MSGPATH log from the time period of the backup
	
	$INFORMIXDIR/etc/$ONCONFIG
	$INFORMIXDIR/etc/sqlhosts
	$INFORMIXDIR/etc/ixbar.<servernum>
	$INFORMIXDIR/etc/oncfg_<servername>.<servernum>
	The contents of this directory:   /usr/openv/netbackup/ext/db_ext/informix/infx_db_comm
	The contents of this directory:   /usr/openv/netbackup/logs/user_ops/dbext/logs
	The backup script, if used
	The environmental variables of the user that is running the restore ('env > env.out 2>&1')
	/usr/openv/netbackup/bp.conf file
	bp.conf file from user Informix's home directory

From any media server that is affected by this issue:
 
	/usr/openv/netbackup/logs/bpcd
	/usr/openv/netbackup/logs/bpbrm
	/usr/openv/netbackup/logs/bptm
	/usr/openv/netbackup/bp.conf file
	The output from the following script:  /usr/openv/netbackup/bin/goodies/support

From the NBU master server:

	/usr/openv/netbackup/logs/bprd
	/usr/openv/netbackup/logs/bpsched
	/usr/openv/netbackup/logs/bpdbm
	/usr/openv/netbackup/bp.conf file
	The output from the following script: /usr/openv/netbackup/bin/goodies/support
	The output from the following command: /usr/openv/netbackup/bin/admincmd/bpcllist -U -allclasses
	A long listing ('ls -l') of this directory: /usr/openv/netbackup/db/images