DB2 temporary tablespace of pagesize 32768 not found

Suatu ketika, saya mendapatkan problem seperti berikut di DB2

2011-11-29-17.20.33.570548-360 I19586119A752      LEVEL: Error
PID     : 8650782              TID  : 21023       PROC : db2sysc 0
INSTANCE: db2inst1             NODE : 000         DB   : BPMDB
APPHDL  : 0-1978               APPID: 192.168.128.4.40793.111129225136
AUTHID  : WPSUSER
EDUID   : 21023                EDUNAME: db2agent (BPMDB) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbGetSysTempDatapool, probe:20
MESSAGE : ZRC=0×80020166=-2147352218=SQLB_NO_TEMP_AVAIL
“Where no temp tablespace is available for use”
DATA #1 : <preformatted>
A useable temporary tablespace of pagesize 32768 was not found.

Berikut langkah untuk mengecek masalah di atas
- cek tablespace
db2 list tablespaces show detail
- catat tablespace ID untuk TEMPSPACE1 (1)
db2 list tablespace containers for 1
- dari 2 langkah di atas kebetulan didapatin bahwa tablespacenya berstatus 0×400

Berikut langkah untuk menyelesaikan masalah diatas
1. buat file / folder untuk dijadikan container atau
2. buat sebuah system temporary tablespace baru
db2 “CREATE SYSTEM TEMPORARY TABLESPACE tmp_tbsp MANAGED BY SYSTEM USING (‘../db2inst1/NODE0000/TESTB/T0000001/C0000001.TMP’)”

This entry was posted in DB2 and tagged , , , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>