Hello All,

I would like to take a transactional log backup in my local disk . Please help me how to perform the same .

Environment info :

AIX 6.1/Db2 9.7 FP2

TERM=xterm
AUTHSTATE=compat
SHELL=/bin/csh
HOME=/db2/db2bis
USER=db2bis
PATH=/db2/db2bis:/usr/sap/BIS/SYS/exe/run:/usr/bin:/etc:/usr/sbin:/usr/ucb:/db2/db2bis/bin:/usr/bin/X11:/sbin:.:/db2/db2bis/sqllib/bin:/db2/db2bis/sqllib/adm:/db2/db2bis/sqllib/misc:/db2/db2bis/sqllib/db2tss/bin
TZ=Europe/Belfast
LANG=en_US
LOCPATH=/usr/lib/nls/loc
LC__FASTMSG=true
ODMDIR=/etc/objrepos
LOGNAME=db2bis
LOGIN=db2bis
SAPSYSTEMNAME=BIS
DIR_LIBRARY=/usr/sap/BIS/SYS/exe/run
DB2INSTANCE=db2bis
INSTHOME=/db2/db2bis
CLASSPATH=/db2/db2bis/sqllib/java/db2jcc_license_cu.jar:/db2/db2bis/sqllib/java/db2jcc.jar:/db2/db2bis/sqllib/function::/db2/db2bis/sqllib/java/db2java.zip:/db2/db2bis/sqllib/java/runtime.zip:.:/db2/db2bis/sqllib/java/db2java.zip:/db2/db2bis/sqllib/java/runtime.zip:.
DB2DBDFT=BIS
dbms_type=db6
dbs_db6_schema=sapbis
MAIL=/var/spool/mail/db2bis
MAILMSG=[YOU HAVE NEW MAIL]
DB2DIR=/db2/db2bis/db2_software
DB2LIBPATH=/db2/db2bis/sqllib/java/jdk64/jre/lib/ppc64
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
LIBPATH=/usr/lib:/lib:/usr/sap/BIS/SYS/exe/run:/db2/db2bis/sqllib/lib64

I understand that i have to set the environment variables USEREXIT,audit_error_loG .. But to be honest i 'm not sure . Really appreciate your help .


Regards
Satish


Regards
Satish

which version of db2 ur using ,
U mean database backup including logs or only want to take logs backup
wht is logging mode archival or circular mode.

regds
Paul

Hello Paul,

Thanks for the reply .

As mentioned earlier mail db2 is on 9.7 FP2 . I just want to take the archive log alone . It's archival method ..

Regards
Satish

db2 update db cfg for <dbname> using logarchmeth1 disk:/db2/log/archivedir

where /db2/log/arhivedir is where the log files are archived to ..
You may use any directory as long as the permissions are set right

hth

Thanks Sathyan ..

Here my question is how to backup the files in log_archive . should it be a manua movement or we need to use any db2 utility to backup the files under log_achive .

Regards
Satish

once the logs are archived, db2 does not control the files anymore. Make sure to take a backup an OS specific method

Thanks you all for the replies .

Regard
Satish