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

File system issue on DB2

Hi Experts, our BI server installed on AIX/DB2, db file system has 4 data files, /db2/SID/sapdata1/data2/data3/data4.we had allocated max space 150 GB for each data file, but currently data1 reached to 94% and remaining all reached to 70%.

my doubt is if the data1 is reached to 100% then the data base reading is stopped or it will read by data2/data3/data4?

we are extracting data daily bases from ECC production to BI.How can I get space in to db file system.

Thanks.

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 18, 2009 at 09:04 PM

    Nani,

    Can you provide some more information about your db. Is it on version 9.5, 9.1 or 9.7, is it using automatic storage etc. If your sapdata1 is utilizing more than the other 3, it would mean that your tablespaces are not stripped evenly across each of the 4 filesystems. Its a best practice to have your tablespaces stripped evenly across your data filesystems to maximize your IO parallelism and to make it easier to manage.

    You would need to check your tablespaces to see which ones "over utilize" sapdata1 and whether those tablespaces have any containers on data2 and data3. For a DMS tablespace, data is written as one extent per container in a round robin fashion across all containers. So if one container becomes full (which is likely in your case) the other containers would still continue to be used (provided they are not on sapdata1

    - Sameer

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Nani,

      I am not sure about the size of the tablespaces sitting on the filesystem which is getting full (the output that you pasted is difficult to read). However, I would do the following:

      1. Get additional disk space and allocate it to your filesystems to ensure that your system remains usable.

      2. Identify the tablespaces that overutilize the sapdata1 filesystem.

      3. Identify the tables in the tablespace identified previously.

      4. Create a new D and I tablespace which is striped evenly across all your filesystems! (assign this to a new data class)

      5. Use DB6CONV to move the tables identified in step 3 to the new tablespace created in step 4/

      Once you move all the tables identified in step 3 to the new tablespace, you would be able to drop the old tablespace. From that point on, ensure that your tablespaces are evenly striped and remain uniformly sized on all the sapdata filesystems.

      - Sameer

  • author's profile photo Former Member
    Former Member
    Posted on Nov 19, 2009 at 10:41 PM

    HI,

    You can move some from datafiles from sapdata1 to other filesystems using db2relocatedb tool.

    Steps will be

    1. shutdown instance

    2. copy over the files to the new locations

    3. run db2relocatedb -f relocate.cfg

    4. db2start

    Also check following link

    http://www.ibm.com/developerworks/data/library/techarticle/dm-0407schlamb/

    Regards,

    Sachin Rane.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 25, 2009 at 07:08 PM

    Hi Nani,

    Have you tried reorging the tablespace via db13?

    Please be aware that space is needed to REORG the table.

    If there is not enough space in the data tablespace, we need the

    temp TS. Do you mean that you have not more disk space available?

    - Please check SAP note 334608 if it helps.

    - Also ensure that SAP Note 796356 is implemented.

    - Can you try to reorg only flagged tables or a set of tables?

    - may be an online REORG allowing write access helps, but

    using the inplace reorg (allow write access) can lead to high system

    utilization. This can have a serious impact to your business processes

    The inplace reorg will take a long time and lock situations can occur

    (during truncation, the table is S-locked!) !

    If a particular tablespace is getting full, you need do the following:

    a) Identify the largest tables or the tables that increase the fastest.

    b) Move these tables to their own tablespaces with the same page sizes,

    as described in note 362325.

    362325 Table conversion using DB6CONV

    Please check if the notes are relevant for your kernel level and db release level as I dont see this information in your messages.

    Regards,

    Paul

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 22, 2010 at 03:03 AM

    Thanks for all your replies.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 27, 2010 at 05:01 PM

    Delivering raw device or better performance for DB2 running on the VERITAS File System ... only is an issue in clusters with three or more nodes.

    __________________

    Download" target="_blank">http://www.microsoftoffice-2010.com/">Download Windows 7

    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.