Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2005
    Posts
    102

    Unanswered: temporary space full errors

    Hi all,

    I am getting these errors almost everyday. They generally occur after a scheduled bulk update that happens every night.

    here's the error:

    2006-06-06-01.16.29.345017-300 E452459A664 LEVEL: Error
    PID : 4268212 TID : 1 PROC : db2pfchr 0
    INSTANCE: xyz NODE : 000
    FUNCTION: DB2 UDB, buffer pool services, sqlbWritePageToDisk, probe:20
    MESSAGE : ADM6017E The table space "TEMP16K" (ID "4") is full. Detected on
    container "/prod1/sms/tmp/tmp16k" (ID "0"). The underlying
    file system is full or the maximum allowed space usage for the file
    system has been reached. It is also possible that there are user
    limits in place with respect to maximum file size and these limits
    have been reached.

    2006-06-06-01.16.29.345327-300 I453124A292 LEVEL: Error
    PID : 4268212 TID : 1 PROC : db2pfchr 0
    INSTANCE: xyz NODE : 000
    FUNCTION: DB2 UDB, buffer pool services, sqlbWritePageToDisk, probe:20
    MESSAGE : Cont page = 82816 ObjID=5 ObjType=128

    2006-06-06-01.16.29.345518-300 E453417A666 LEVEL: Error
    PID : 4268212 TID : 1 PROC : db2pfchr 0
    INSTANCE: xyz NODE : 000
    FUNCTION: DB2 UDB, oper system services, sqloseekwrite64, probe:100
    MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full."
    DIA8312C Disk was full.
    DATA #1 : File handle, PD_TYPE_SQO_FILE_HDL, 8 bytes
    0x0FFFFFFFFFFFD310 : 0000 000E 0000 0000 ........
    DATA #2 : unsigned integer, 8 bytes
    16384
    DATA #3 : signed integer, 8 bytes
    1353777152
    DATA #4 : unsigned integer, 8 bytes
    40
    DATA #5 : Hex integer, 4 bytes
    0x0000001C
    DATA #6 : signed integer, 8 bytes
    -1
    ----------------------------------------------------------

    Now the thing is that the location for container mentioned in the error is not full, its just using 2-3% of the space allocated to it.

    So I am not understanding where the problem resides. I hope I can get some advice from here.

    Also I would like to know the impact of these errors??

    Anks

  2. #2
    Join Date
    Jul 2005
    Posts
    102
    I am sorry I forgot to mention the version and OS info


    DB2 UDB v8.2, FP 7, AIX

    Anks

  3. #3
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    Is the table space "TEMP16K" system-managed or database-managed?
    And if it's DMS, is there a size limit specified?

    What is the current file size of /prod1/sms/tmp/tmp16k ?
    Does the disk have accounting or other user-based space limitations switched on?
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

  4. #4
    Join Date
    Jul 2005
    Posts
    102
    Thanks Peter

    Its System Managed Tablespace

    After doing a ulimit, here's what I see

    ulimit -a
    time(seconds) unlimited
    file(blocks) unlimited
    data(kbytes) 245760
    stack(kbytes) 16384
    memory(kbytes) unlimited
    coredump(blocks) unlimited
    nofiles(descriptors) unlimited

    I don't know if the data and stack should also be kept as unlimited.

    The size of the filesystem is this

    df -k /prod1/sms/tmp
    Filesystem 1024-blocks Free %Used Iused %Iused Mounted on
    /dev/fslv03 4194304 4178404 1% 316 1% /prod1/sms/tmp


    du -k /prod1/sms/tmp/xyz

    1308 /prod1/sms/tmp/xyz/tmp16k
    1948 /prod1/sms/tmp/xyz/tmp32k
    8 /prod1/sms/tmp/xyz/tmp4k
    3264 /prod1/sms/tmp/xyz

    Don't know if all this information will help

    Let me if you need more information

    Anks

  5. #5
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    The "data" limit looks fine; quoting from http://publib.boulder.ibm.com/infoce...perftune25.htm
    "It is recommended that the process data size and virtual memory size be set to unlimited. Setting to unlimited can be done by modifying the following lines in the /etc/security/limits file:

    default:
    data = -1
    rss = -1

    At minimum, set these size limits to 256 MB, which is the value of 256000 in the /etc/security/limits file."

    Only 2 MB is being used up.
    Are you sure that those limits apply to DB2?
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

  6. #6
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    SMS temporary space is allocated is needed. I'm sure that if you monitor the space utilization during the "bulk update" process you'll see that it approaches 100% just before the process failure.

  7. #7
    Join Date
    Jul 2005
    Posts
    102
    I have set the data limits to "unlimited" and i'll monitor the utilization at the time of the bulk update to see what happens.

    Thanks for all your help!!

Posting Permissions

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