Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2003
    Posts
    77

    Question Unanswered: create long tablespace failing

    Using DB2 7.2, Win NT,

    Create long tablespace (of DMS type) command is failing with DIA3612C Disk was full error in diag.log even when there is space on disk.
    The total container files in create tablespace statement need less than 80GB of space. The file system has 150 GB of free space in it.

    The command looks like -

    CREATE LONG TABLESPACE tbspc1 IN NODEGROUP IBMDEFAULTGROUP PAGESIZE 4096 MANAGED BY DATABASE USING (FILE 'D:\Data\cont1.DB' 2560000, FILE 'D:\Data\cont2.DB' 2560000, FILE 'D:\Data\cont3.DB' 2560000, FILE 'D:\Data\cont4.DB' 2560000, FILE 'D:\Data\cont5.DB' 2560000,FILE 'D:\Data\cont6.DB' 2560000 ) EXTENTSIZE 32 PREFETCHSIZE 32 BUFFERPOOL IBMDEFAULTBP OVERHEAD 11.670000 TRANSFERRATE 0.310000

    Since the disk has space, can there be any other reason for this error? All the tablespaces are DMS, including catalog.

    Following is from db2diag.log -

    2004-10-07-18.52.54.765000 InstanceB2 Node:000
    PID:1224(db2syscs.exe) TID:1696 Appid:none
    buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0

    Prefetcher Error rc = -10740 IGNORED ... err loc 0
    . Request follows...

    2004-10-07-18.52.54.828000 InstanceB2 Node:000
    PID:1224(db2syscs.exe) TID:1696 Appid:none
    buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0

    type = ADDDMSCONTAINER

    2004-10-07-18.52.55.265000 InstanceB2 Node:000
    PID:1224(db2syscs.exe) TID:1076 Appid:none
    buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0

    Prefetcher Error rc = -10740 IGNORED ... err loc 0
    . Request follows...

    2004-10-07-18.52.55.265001 InstanceB2 Node:000
    PID:1224(db2syscs.exe) TID:1076 Appid:none
    buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0

    type = ADDDMSCONTAINER

    2004-10-07-18.52.55.328000 InstanceB2 Node:000
    PID:1224(db2syscs.exe) TID:2272 Appid:*LOCAL.DB2.041007235251
    buffer_pool_services sqlbDMSCreatePool Probe:800 Database:T1DB
    DIA3612C Disk was full.

    ZRC=FFFFD60C

    2004-10-07-18.52.55.343000 InstanceB2 Node:000
    PID:1224(db2syscs.exe) TID:2272 Appid:*LOCAL.DB2.041007235251
    buffer_pool_services sqlbDMSCreatePool Probe:800 Database:T1DB

    Page=110

    2004-10-07-18.52.55.343001 InstanceB2 Node:000
    PID:1224(db2syscs.exe) TID:2272 Appid:*LOCAL.DB2.041007235251
    buffer_pool_services sqlbCreatePool Probe:920 Database:T1DB
    DIA3612C Disk was full.

    ZRC=FFFFD60C

    2004-10-07-18.52.55.906000 InstanceB2 Node:000
    PID:1224(db2syscs.exe) TID:2272 Appid:*LOCAL.DB2.041007235251
    data_management sqldPoolCreate Probe:273 Database:T1DB
    DIA3612C Disk was full.

    ZRC=FFFFD60C

    Thanks,
    -Preeti

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Long Tablespaces are for long or LOB table columns. It does not affect the total size of the tablespace. If you want a tablespace larger than 64 GB (but no more than 128 GB), use an 8K page size. If 128 GB is not enough, keep increasing the page size.

    Refer to the SQL limits, Appendix A, of the SQL Reference, where it has: Table 36. Database Manager Page Size Specific Limits.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jun 2003
    Posts
    77
    We do have LOB columns in the table which will be connected to this long tablespace.

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    If you are going over 64GB, you need a page size larger than 4K.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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