ÁÉ­}ºô > IT§Þ³N ¼Æ¾Ú®w > ºë±m§ó·s
  IT¸ê°T·j¯Á
 
IT²£«~·j¯Á
[µ{¦¡¶}µo][ºôºÞ¥@¬É][ºô¸ô¦w¥þ][¼Æ¾Ú®w§Þ³N]
[§@·~¨t²Î][¹Å»«²á¤Ñ¡P½u¤W³X½Í][¬¡°Ê¶°ÀA]
[ºë±m±MÃD][Symantec±M°Ï][­q¾\IT§Þ³N¶g¥Z]
[¶}µo½×¾Â][ºôºÞ½×¾Â][¦w¥þ½×¾Â][¼Æ¾Ú®w½×¾Â]
[§@·~¨t²Î½×¾Â][Sybase±M°Ï][IBM dW§Þ³N±M°Ï]
[¯f¬r¨D§U][¯f¬r»Pº|¬}¼½³ø][¤åÀÉ¡P·½½X¤U¸ü]

SQL0290NªíªÅ¶¡ª¬ºA°ÝÃD¡G°±¹yªº¿W¦û³B²z

µo§G®É¶¡¡G2008.07.16 04:46     ¨Ó·½¡GÁÉ­}ºô    §@ªÌ¡G±ï®ä

¡iÁÉ­}ºô¡ÐIT§Þ³N³ø¹D¡j¤µ¤Ñ¤@­Ó¦P¨Æ³ø§i¤@­Ó°ÝÃD¡Aªí³£¤£¯à¨Ï¥Î¤F,Àˬd¤F¤@¤U¡Aµo²{

°ÝÃD db2 => select * from test

ACTNO ACTKWD ACTDESC

------ ------ --------------------

SQL0290N Table space access is not allowed. SQLSTATE=55039

¨ä¥Lªí¤]¤£¯à¨Ï¥Î

¦bdb2ccùجd¬ÝªíªÅ¶¡ª¬ºA¬°¡G °±¹yªº¿W¦û

¸Ñ¨M¤èªk¡G

¨ì©R¥O¦æª¬ºA¡A­º¥ýconnect ¨ì»Ý­n³B²zªº¼Æ¾Ú®w

¡»1¡Bdb2 => list tablespaces show detail Åã¥ÜªíªÅ¶¡ª¬ºA

Tablespaces for Current Database

Tablespace ID = 0

Name = SYSCATSPACE

Type = System managed space

Contents = Any data

State = 0x0000

Detailed explanation:

Normal

Total pages = 2519

Useable pages = 2519

Used pages = 2519

Free pages = Not applicable

High water mark (pages) = Not applicable

Page size (bytes) = 4096

Extent size (pages) = 32

Prefetch size (pages) = 32

Number of containers = 1

Tablespace ID = 1

Name = TEMPSPACE1

Type = System managed space

Contents = System Temporary data

State = 0x0000

Detailed explanation:

Normal

Total pages = 1

Useable pages = 1

Used pages = 1

Free pages = Not applicable

High water mark (pages) = Not applicable

Page size (bytes) = 4096

Extent size (pages) = 32

Prefetch size (pages) = 32

Number of containers = 1

Tablespace ID = 2

Name = USERSPACE1

Type = System managed space

Contents = Any data

State = 0x0004 ³o­Ó¥N½X·N¸q´N¬O¡§°±¹yªº¿W¦û¡¨¡A¥¿±`ª¬ºA¬°0x0000¡A

«D0´N¬O¦³°ÝÃD¡A³£¥i¥H¥Î¤U­±¤èªk¸Ñ¨M¡C

Detailed explanation:

Quiesced: EXCLUSIVE

Total pages = 687

Useable pages = 687

Used pages = 687

Free pages = Not applicable

High water mark (pages) = Not applicable

Page size (bytes) = 4096

Extent size (pages) = 32

Prefetch size (pages) = 32

Number of containers = 1

Number of quiescers = 1 ª`·N¤U­±´X¦æ

Quiescer 1:

Tablespace ID = 2

Object ID = 50 ¡§object id¬O³y¦¨¦ºÂêªíªºid¡¨

¡»2¡Bdb2 => select tabname from syscat.tables where tableid=50 ³q¹L©Ò¦íªºid¸¹§ä¥X¬O­þ­Óªí¡C

TABNAME

--------------------------------------------

SYSINDEXEXTENSIONPARMS

TEST ´N¬O³o­Óªí

2 record(s) selected.

¡»3¡Bdb2 => quiesce tablespaces for table test reset °õ¦æ¸Ó©R¥O²M°£¿ù»~ªºª¬ºA

DB20000I The QUIESCE TABLESPACES command completed successfully.

¡»4¡B­«·sselect¡A°ÝÃD¸Ñ¨M

¡»5¡B¤ñ¸û±`¨£¾É­P§ïºØ°ÝÃDªº­ì¦]¬O¡A«D¥¿±`ªº¤¤¤î¥¿¹ïªí¶i¦æªº¾Þ§@¡A¾É­P¹ïªíªÅ¶¡ªº¨Ï¥Î¨S¦³¥¿±`ªºÄÀ©ñ¡C¡]³d¥ô½s¿è¡G¿c¥üªL¡^


[ µoªíµû½× ] ¦rÅé[ ¤j¡B¤¤¡B¤p ] [ ¦C¦L ] [ ¶i¤J³Õ«È ] [ ¶i¤J½×¾Â ]  [ ±ÀÂ˵¹ªB¤Í ]
  ¡i¬ÛÃö¤å³¹¡j
  ¡i«È¤á»Ý¨D¤ÏõXªí¡j
* ©m¡@¡@¦W:
§ó¦h¸ê®Æ¡@ ¤F¸Ñ¤è®×¡@ »{ÃѼt°Ó
* ³æ¦ì¦WºÙ:
* Ápô¹q¸Ü:
* ¹q¤l¶l¥ó:
  ÁÉ­}±ÀÂË  
  ¤â¾÷¡P¸ê¶O ¡P·s«~¡P¾ÉÁÊ¡Pµû´ú¡P¤â¾÷¸ê¶O¡P¼e±a
¤â¾÷·j¯Á  ¿Õ°ò¨È N73 MOTO Z6
  IT²£«~ ¡Pµ§°O¥»¡P»O¦¡¾÷¡P¦øªA¾¹¡P¦C¦L¡P§ë¼v
IT²£«~·j¯Á 
  IT§Þ³N ¡P¶}µo¡PºôºÞ¡P¦w¥þ¡P¼Æ¾Ú®w¡P§@·~¨t²Î
  ¸ê°T¤Æ ¡P¼öÂI¡P±MÃD¡P³X½Í¡P¶g¥Z¡P¤è®×®×¨Ò
¡P ¸ê°T¤Æ¥«³õ¦Ê®aª§»ï SaaS²`³´ª§Ä³¡§ªd¼æ¡¨
¡P ´£°ªºÞ²z¤ô·Ç "¨â´Ï"CIOÀ³¨ã³Æªº¤»¤j¯à¤O
¡P °ê²£ITIL¹Bºû¥ý¦æªÌ ¥|¤j¼t°Ó¨¤¤OBI¥«³õ
¡P ª÷¿Ä¦æ·~GSN±MÃD¸Ñ¨M¤è®× ¥ø·~ºô¸Ñ¨M¤è®×
  IT³Õ«È ¡P´¿¼C¬î¡P¶µ¥ß­è¡PJava¾Ç²ß¡PºôºÞ
  IT§Þ³N½×¾Â ¡P¶}µo¡PºôºÞ¡P¦w¥þ¡P¼Æ¾Ú®w¡P¨t²Î