Results 1 to 7 of 7
  1. #1
    Join Date
    Mar 2011
    Posts
    41

    Question Unanswered: Transactional lg backup

    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

  2. #2
    Join Date
    Oct 2007
    Posts
    246
    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

  3. #3
    Join Date
    Mar 2011
    Posts
    41
    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

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    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
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  5. #5
    Join Date
    Mar 2011
    Posts
    41
    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

  6. #6
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    once the logs are archived, db2 does not control the files anymore. Make sure to take a backup an OS specific method
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  7. #7
    Join Date
    Mar 2011
    Posts
    41
    Thanks you all for the replies .

    Regard
    Satish

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •