Skip to Content
author's profile photo Former Member
Former Member

DB2 implementation on AIX

We are looking to migrate some mainframe databases to AIX DB2.

A number of questions have cropped up that I can't find any answers to.

a) File systems. From the documentation the core db2 file systems are.

/db2/db2<SID>

/db2/<SID>/log_dir

/db2/<SID>/log_dir2

/db2/<SID>db2dump

/db2/<SID>/sapdata<n>

Is there not an equivalent of an archive dump area as will oracle? I.e. the logs are copied to this for further archiving off to tape?

b) EMC timefinder integration with DBA cockpit.

Using IBM storage snap based backups are integrated via the Db2 tools that can be called from DBACOCKPIT, however although the documentation states that it is possible to use timefinder I can't find any information on the integration? Do we have to create our own scripts to call from DBACOCKPIT

to enable this?

Any help would be greatly appriciated.

Cheers


/db2/db2<SID>













/db2/db2<SID> /db2/<SID>/log_dir /db2/<SID>/log_dir2 /db2/<SID>db2dump /db2/<SID>/sapdata<n>


/db2/<SID>/log_dir


/db2/<SID>/log_dir2


/db2/<SID>db2dump


/db2/<SID>/sapdata<n>














/db2/db2<SID> /db2/<SID>/log_dir /db2/<SID>/log_dir2 /db2/<SID>db2dump /db2/<SID>/sapdata<n>













/db2/db2<SID> /db2/<SID>/log_dir /db2/<SID>/log_dir2 /db2/<SID>db2dump /db2/<SID>/sapdata<n>
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jul 01, 2012 at 04:54 AM

    1. Typically in a DB2 installation , you require the following filesystems which should suffice the need.

    /db2

    /db2/<SID>

    /db2/db2<sid>

    /db2/<SID>/db2dump

    /db2/<SID>/log_dir

    /db2/<SID>/sapdata<1..n>

    In DB2 there are 2 locations where transaction logs are stored under /db2/<SID>/log_dir and

    the location specified by the database cinfiguration parameter LOGARCHMETH1. Once the log

    file is filled up in the directory /db2/<SID>/log_dir , it is immediate transferred to the

    location specified by LOGARCHMETH1. In oracle you have 3 locations where redo logs can reside

    , the online redolog path , the oraarch directory and finally the backup location. In DB2

    the location of LOGARCHMETH1 is the backup location.

    You can get details on logging mechanism in the link

    http://www.ibm.com/developerworks/data/library/techarticle/0301kline/0301kline.html

    You can download the doc under

    http://scn.sap.com/docs/DOC-14444

    This is a very useful document which IBM uses to enable customers with DB2 administration skills.

    You can use a number of database parameters according to the need for transaction logs and archived transaction logs such as MIRRORLOGPATH,FAILARCHPATH,OVERFLOWLOGPATH , the deatils which you can find in the above document .

    2. For integrating EMC timefinder , you can check the below link

    http://www.emc.com/collateral/software/technical-documentation/h6023-using-timefinder-back-up-restore-linux-unix-windows-tech-book.pdf

    You can also refer this doc for additional reference

    http://www.emc.com/collateral/hardware/technical-documentation/csg5125-300-003-506-elccnt.pdf

    Regards

    Ratnajit

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 29, 2012 at 08:39 PM

    this what we generally create when it comes down file systems related to db2

    /db2/db2<sid> /db2/<SID>/db2dump /db2/<SID>/db2<sid> /db2/<SID>/log_archive /db2/<SID>/log_archive2 /db2/<SID>/log_dir /db2/<SID>/log_dir2 /db2/<SID>/log_retrieve /db2/<SID>/sapdata1 /db2/<SID>/sapdata2 /db2/<SID>/sapdata3 /db2/<SID>/sapdata4 /db2/<SID>/sapdata5 /db2/<SID>/sapdata6 /db2/<SID>/sapdata7 /db2/<SID>/sapdata8

    Regards

    Amit Padmawar

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.