Topic
  • 3 replies
  • Latest Post - ‏2014-08-12T09:18:57Z by mor
Rizwan Ali Joo
Rizwan Ali Joo
36 Posts

Pinned topic DIA8312C Disk was full.

‏2014-08-11T07:31:46Z |

Dear All,

we are running Db2 9.7.0.3 on AIX 6. The db2diag.log file is continuously showing the following errors, please help me out with this.

2014-08-08-01.08.33.667427+300 E22633164A1127     LEVEL: Error (OS)

PID     : 7274678              TID  : 772         PROC : db2acd 0

INSTANCE: db2inst1             NODE : 000

EDUID   : 772                  EDUNAME: db2acd 0

FUNCTION: DB2 UDB, oper system services, sqlowrite, probe:60

MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full."

          DIA8312C Disk was full.

CALLED  : OS, -, write

OSERR   : EFBIG (27) "A file cannot be larger than the value set by ulimit."

DATA #1 : File handle, PD_TYPE_SQO_FILE_HDL, 8 bytes

  File Handle              = 9

  File System Block Size   = 0 bytes

  File System Type         = UNKNOWN

  File Handle Flags :

    Require Sector Align   = No

    DIO/CIO Mode           = No

    Raw Block Device       = No

    Reserved Handle        = No

    Flush On Close         = No

    Thread-Level Lock      = No

    Write-through Mode     = No

    File Not Tracked       = No

DATA #2 : unsigned integer, 8 bytes

314

DATA #3 : signed integer, 8 bytes

-1

DATA #4 : String, 105 bytes

Search for ossError*Analysis probe point after this log entry for further

self-diagnosis of this problem.

 

2014-08-08-01.08.33.683860+300 I22634292A2599     LEVEL: Error (OS)

PID     : 7274678              TID  : 772         PROC : db2acd 0

INSTANCE: db2inst1             NODE : 000

EDUID   : 772                  EDUNAME: db2acd 0

FUNCTION: DB2 Common, OSSe, ossErrorIOAnalysis, probe:100

CALLED  : OS, -, write

OSERR   : EFBIG (27) "A file cannot be larger than the value set by ulimit."

DATA #1 : String, 145 bytes

A total of 5 analysis will be performed :

 - User info

 - ulimit info

 - Target file info

 - I/O attempt

 - File system

 

 Target file handle = 9

DATA #2 : String, 186 bytes

  Real user ID of current process       = 1004

  Effective user ID of current process  = 1004

  Real group ID of current process      = 999

  Effective group ID of current process = 999

DATA #3 : String, 380 bytes

Current process limits (unit in bytes except for nofiles) :

  mem     (S/H) = unlimited / unlimited

  core    (S/H) = unlimited / unlimited

  cpu     (S/H) = unlimited / unlimited

  data    (S/H) = unlimited / unlimited

  fsize   (S/H) = unlimited / unlimited

  nofiles (S/H) = unlimited / unlimited

  stack   (S/H) = 4294967296 / 4294967296

  rss     (S/H) = 33554432 / unlimited

DATA #4 : String, 41 bytes

current sbrk(0) value: 0x0000000111581aa0

DATA #5 : String, 264 bytes

Target File Information :

  Size               = 2147483647

  Link               = No

  Reference path     = N/A

  Type               = 0x8000

  Permissions        = rw-rw-rw-

  UID                = 1004

  GID                = 999

  Last modified time = 1385417118

DATA #6 : String, 33 bytes

I/O attempt not implemented yet.

DATA #7 : String, 378 bytes

File System Information of the target file :

  Block size        = 4096 bytes

  Total size        = 16106127360 bytes

  Free size         = 12742287360 bytes

  Total # of inodes = 3932160

  FS name           = N/A

  Mount point       = /usrhome

  FSID (major,minor)= 6, 18

  FS type name      = jfs

  DIO/CIO mount opt = None

  Device type       = N/A

  FS type           = 0x5

CALLSTCK:

  [0] 0x090000000A0213A4 pdOSSeLoggingCallback + 0x44

  [1] 0x090000000140B064 oss_log__FP9OSSLogFacUiN32UlN26iPPc + 0x1C4

  [2] 0x090000000140B540 ossLogSysRC + 0xA0

  [3] 0x090000000142AAAC ossErrorIOAnalysis__FCPC21OSSErrorAnalysisParam + 0xC8C

  [4] 0x090000000142CB48 ossErrorAnalysis@AF12_1 + 0x48

  [5] 0x090000000A6C90F4 sqloSystemErrorHandler + 0x3E4

  [6] 0x090000000A6DAA9C sqloSystemErrorHandler@glue1E2 + 0x124

  [7] 0x090000000A056660 sqlowrite + 0x404

  [8] 0x090000000A6DC178 @75@sqltfast2__FP8SQLT_CFPUiPvT2 + 0x1618

  [9] 0x090000000A5BD654 sqlt_logadmin + 0x1D8

Thanks and Regards,

Rizwan Ali Joo

  • mor
    mor
    577 Posts
    ACCEPTED ANSWER

    Re: DIA8312C Disk was full.

    ‏2014-08-12T09:18:57Z  

    MOR, yes we have JFS file system, please refer me the LInk or procedure to enable large file support.

     

    Thanks  and regards,

    Rizwan

    Ask your system administrator.

    You should follow the db2 documentation recommendations for the file systems to use with DB2 on AIX:  JFS2  see the page in the link below

    http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.admin.dbobj.doc/doc/r0056470.html?lang=en

     

  • mor
    mor
    577 Posts

    Re: DIA8312C Disk was full.

    ‏2014-08-11T15:36:52Z  

    Is the "type" of the file-system "JFS" (as indicated above)  or is it "JFS2".

     

    If it is JFS  (and not jfs2) then ask your sysadmin to enable large file support.

     

    If the filesystem is jfs2, check if the following applies to you:

    http://www-01.ibm.com/support/docview.wss?uid=swg21258459

    b

  • Rizwan Ali Joo
    Rizwan Ali Joo
    36 Posts

    Re: DIA8312C Disk was full.

    ‏2014-08-12T07:17:13Z  
    • mor
    • ‏2014-08-11T15:36:52Z

    Is the "type" of the file-system "JFS" (as indicated above)  or is it "JFS2".

     

    If it is JFS  (and not jfs2) then ask your sysadmin to enable large file support.

     

    If the filesystem is jfs2, check if the following applies to you:

    http://www-01.ibm.com/support/docview.wss?uid=swg21258459

    b

    MOR, yes we have JFS file system, please refer me the LInk or procedure to enable large file support.

     

    Thanks  and regards,

    Rizwan

  • mor
    mor
    577 Posts

    Re: DIA8312C Disk was full.

    ‏2014-08-12T09:18:57Z  

    MOR, yes we have JFS file system, please refer me the LInk or procedure to enable large file support.

     

    Thanks  and regards,

    Rizwan

    Ask your system administrator.

    You should follow the db2 documentation recommendations for the file systems to use with DB2 on AIX:  JFS2  see the page in the link below

    http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.admin.dbobj.doc/doc/r0056470.html?lang=en