æ¬ãµã¤ã㯠IBM製RDBMSã§ããDB2ã®éå¼ãæ©è½ãªãã¡ã¬ã³ã¹ã§ãã æè¡è©è«ç¤¾ããåºçããã¦ããååæ¸ç±ã®ã³ã³ãã³ãããã¼ã¹ã¨ãã¦ãã¾ãã ãã®ããã»ã¨ãã©ã®ãã¼ã¸ãDB2ãã¼ã¸ã§ã³8.1.5ãã¼ã¹ã®è¨è¿°ã«ãªã£ã¦ãã¾ãã8.2以éã§è¿½å ãããæ°æ©è½ã«ã¤ãã¦ã¯ãã¡ãã«è¿½è£ã¨ãã¦ã¾ã¨ãã¦ããã¾ãã å°æ¥çã«åºçå¾ã®ã¢ãããã¼ããªã©ãåæ ããå 容ã«æ´æ°ãã¦ããäºå®ã§ãã ãã¡ããã DB2éå¼ããªãã¡ã¬ã³ã¹ç®æ¬¡ DB2éå¼ãWiki:å 責äºé
**DB2 ããã©ã³ã¶ã¯ã·ã§ã³ãã°ããã£ã±ãã ãã¼ãã«ã®ã¬ã³ã¼ãã貯ããããå ´åãåé¤ã®éä¸è¨ã®ã¡ãã»ã¼ã¸ãåºåã㦠åé¤ã«å¤±æãããã¨ãããã¾ããï¼åé¤å¦çã¯ãã¼ã«ããã¯ããã¦æ»ã£ã¦ãã¾ãã¾ããï¼ $ db2 delete from xxxxxtbl DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0964C The transaction log for the database is full. SQLSTATE=57011 åé¤ããåä½ãå°ãããã以å¤ã®æ¹æ³ã¨ãã¦ä¸è¨ãããã¾ãã ãã©ã³ã¶ã¯ã·ã§ã³ãã°ãä¸æ¯ã«ãªã£ãã¨ããå ´åã®ã
表ã®å 容ãåé¤ããã«ã¯DELETEæã使ç¨ãã¾ããããã®å ´åLOGãåºåãããã®ã§ã大éã®ãã¼ã¿ãåé¤ããå ´åã¯æéãæããã¾ãã å 容ãä¿åãããªãã¦ãè¯ãåã«å ¨ãã¼ã¿ãåé¤ãããå ´åãOracleãªã©ã§ã¯TRUNCATE TABLEã¹ãã¼ãã¡ã³ãã使ç¨ãã¾ãããDB2ã«ã¯ããã¾ããã â»2010/04/25追è¨:DB2 v9.7ããTRUNCATE TABLEã追å ããã¾ããã â»TRUNCATEã¹ãã¼ãã¡ã³ã DB2ã®å ´åã以ä¸ã®æ¹æ³ã使ç¨ãã¾ãã 1) ALTER TABLEã³ãã³ãã§ACTIVATE NOT LOGGED INITIALLYã表ã«é©ç¨ãã ACTIVATE NOT LOGGED INITIALLYãè¡ãã¨ãCOMMITã¾ã§LOGãåãããªããªãã®ã§ããã®éã«DELETEããCOMMITãã¾ãã 2) IMPORTã³ãã³ãã§ãã¡ã¤ã«å®¹é=0ã®ãã¡ã¤ã«ãIMPORTã
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}