急需解决的问题呀,大家帮忙,在线等待
db2装载数据的时候表空间满,使得表空间的状态变成LOAD PENDING,
本人使用DB2 LOAD CLIENT FROM F:\M0202I.TXT OF DEL TERMINATE INSERT INTO MYTABLE试图改变状态,但是提示如下错误 SQL3034N The keyword INTO is missing from the target specification or it is misspelled.
请问各位老大,怎么解决呢?
以前表空间没有满的情况下,用该语句就可以改变状态,现在怎么办?
Tablespace ID = 3
Name = USRSPACE1
Type = Database managed space
Contents = Any data
State = 0x000c
Detailed explanation:
Quiesced: EXCLUSIVE
Load pending
Total pages = 16777216
Useable pages = 16777152
Used pages = 0
Free pages = 0
High water mark (pages) = 0
Page size (bytes) = 4096
Extent size (pages) = 32
Prefetch size (pages) = 32
Number of containers = 2
State change tablespace ID = 3
State change object ID = 3855
Number of quiescers = 1
Quiescer 1:
Tablespace ID = 3
Object ID = 3855