DB2 Tablespace Backup Pending Status

Berikut DB2 Command  untuk me-list tablesapce in pending status:

SELECT SNAPSHOT_TIMESTAMP,TBSP_NAME,DBPARTITIONNUM,TBSP_I D,TBSP_STATE,TBSP_PREFETCH_SIZE,TBSP_NUM_QUIESCERS ,TBSP_STATE_CHANGE_OBJECT_ID,TBSP_STATE_CHANGE_TBS P_ID,TBSP_MIN_RECOVERY_TIME,TBSP_TOTAL_PAGES,TBSP_ USABLE_PAGES,TBSP_USED_PAGES,TBSP_FREE_PAGES,TBSP_ PENDING_FREE_PAGES,TBSP_PAGE_TOP,REBALANCER_MODE,R EBALANCER_EXTENTS_REMAINING,REBALANCER_EXTENTS_PRO CESSED,REBALANCER_PRIORITY,REBALANCER_START_TIME,R EBALANCER_RESTART_TIME,REBALANCER_LAST_EXTENT_MOVE D,TBSP_NUM_RANGES,TBSP_NUM_CONTAINERS,TBSP_INITIAL _SIZE,TBSP_CURRENT_SIZE,TBSP_MAX_SIZE,TBSP_INCREAS E_SIZE,TBSP_INCREASE_SIZE_PERCENT,TBSP_LAST_RESIZE _TIME,TBSP_LAST_RESIZE_FAILED
FROM "SYSIBMADM"."SNAPTBSP_PART"
where TBSP_STATE<>'NORMAL' order by TBSP_NAME, DBPARTITIONNUM

Untuk memperbaiki  Tablespace Backup Pending Status agar kembali Normal, jalankan query berikut:
db2 "backup db bcudb on dbpartitionnums(0,1,2,3,4,5,6) tablespace (USERSPACE1) online to /dev/null without prompting"

source: http://www.dbforums.com/6464821-post5.html

Advertisements

About davidand

Hi, welcome to my blogs. My name is David Andriansyah. I am currently working as an independent Cognos Business Intelligence consultant, and I also as Freelance Web Developer. View all posts by davidand

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: