Oracle和DB2的转换
1、取前N条记录 Oracle:Select * from TableName where rownum <= N; DB2:Select * from TableName fetch first N rows only; 2、取得系统日期 Oracle:Select sysdate from dual; DB2:Select current tim...
DB2恢复错误 SQL2059W
昨日在恢复数据库冷备份过程中碰到如下错误restore database testdb continueSQL2059W A device full warning was encountered on device "DATATBS00_8K".Do you want to continue(c), terminate this d...
在AIX 上安装DB2 碰到的错误
这两天因为工作需要,搭建DB2 9.1 For AIX 5.3, DB2 8.1 For AIX 5.2环境。总的来讲还算顺利,不过也碰到不少问题,共享一下经验。 1。获取安...