DB2?????????????????
???????????? ???????[ 2014/6/4 18:45:12 ] ????????
????DB2??????????????????????????????????????DB2??????????????????????????????????????????????????????????鵵??????????????????????????????á?
??????DB2???????????????????
??????????????? SAMPNEW ?????·???2?????? SAMPLE ????????·???μ?鵵?????????????????????????????? SAMPLE ??鵵???????????????????·???£?????????????????????? OVERFLOW ??????????·????????? SAMPNEW ???????????·??????????????????鵵????????
?????????? SAMPLE ?????鵵???????·??????????????????
db2_all "db2 get db cfg for sample" | grep "Path"
Path to log files = /home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/
Path to log files = /home/db2inst1/db2inst1/NODE0001/SQL00001/SQLOGDIR/
Path to log files = /home/db2inst1/db2inst1/NODE0002/SQL00001/SQLOGDIR/
Path to log files = /home/db2inst1/db2inst1/NODE0003/SQL00001/SQLOGDIR/
??????????軔????????鵵?????????????? /sampnew ?£?????????????????????????У???????????????????????????????????β??????????????????д???
db2 "rollforward db sampnew to end of logs and complete overflow log path
??/sampnew/NODE0000/SQL00001/SQLOGDIR??
/sampnew/NODE0001/SQL00001/SQLOGDIR on dbpartitionnum 1??
/sampnew/NODE0002/SQL00001/SQLOGDIR on dbpartitionnum 2??
/sampnew/NODE0003/SQL00001/SQLOGDIR on dbpartitionnum 3??
)"
???????????0????????? OVERFLOW ????в??????“ON DBPARTITIONNUM 0”????????????????
????SQL0104N An unexpected token "on" was found following "<identifier>". Expected tokens may include: ")". SQLSTATE=42601???????????????????????
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11