Just installed DB2 version 10. Practice creating an oracle-compatible database:
$db2set DB2_COMPATIBILITY_VECTOR=ora $db2stop force 05/22/2012 21:44:21 0 0 SQL1064N DB2STOP processing was successful. SQL1064N DB2STOP processing was successful. $db2start 05/22/2012 21:44:33 0 0 SQL1063N DB2START processing was successful. SQL1063N DB2START processing was successful. $db2sampl -name osample Creating database "osample"... Connecting to database "osample"... Creating tables and data in schema "DB2ADMIN"... Creating tables with XML columns and XML data in schema "DB2ADMIN"... 'db2sampl' processing complete.
$db2 +o connect to osample $db2 -x "select 1 from dual" 1 $db2 list tables for SYSTEM | grep DBA_ DBA_ALL_TABLES SYSIBMADM V 2012-05-22-22.00.47.959006 DBA_ARGUMENTS SYSIBMADM V 2012-05-22-22.00.44.054001 DBA_CATALOG SYSIBMADM V 2012-05-22-22.00.44.391002 DBA_COL_COMMENTS SYSIBMADM V 2012-05-22-22.00.44.659001 DBA_CONSTRAINTS SYSIBMADM V 2012-05-22-22.00.44.929001 DBA_CONS_COLUMNS SYSIBMADM V 2012-05-22-22.00.44.778008 DBA_DEPENDENCIES SYSIBMADM V 2012-05-22-22.00.45.054001 DBA_ERRORS SYSIBMADM V 2012-05-22-22.00.45.272005 DBA_INDEXES SYSIBMADM V 2012-05-22-22.00.45.625001 DBA_IND_COLUMNS SYSIBMADM V 2012-05-22-22.00.45.423001 DBA_IND_PARTITIONS SYSIBMADM V 2012-05-22-22.00.45.515001 DBA_OBJECTS SYSIBMADM V 2012-05-22-22.00.45.707002 DBA_PART_INDEXES SYSIBMADM V 2012-05-22-22.00.45.807001 DBA_PART_KEY_COLUMNS SYSIBMADM V 2012-05-22-22.00.45.940006 DBA_PART_TABLES SYSIBMADM V 2012-05-22-22.00.46.007004 DBA_PROCEDURES SYSIBMADM V 2012-05-22-22.00.46.091005 DBA_ROLES SYSIBMADM V 2012-05-22-22.00.48.646006 DBA_ROLE_PRIVS SYSIBMADM V 2012-05-22-22.00.46.224005 DBA_SEQUENCES SYSIBMADM V 2012-05-22-22.00.46.299008 DBA_SOURCE SYSIBMADM V 2012-05-22-22.00.46.475001 DBA_SYNONYMS SYSIBMADM V 2012-05-22-22.00.46.592000 DBA_SYS_PRIVS SYSIBMADM V 2012-05-22-22.00.46.750004 DBA_TABLES SYSIBMADM V 2012-05-22-22.00.47.910004 DBA_TABLESPACES SYSIBMADM V 2012-05-22-22.00.48.236001 DBA_TAB_COLUMNS SYSIBMADM V 2012-05-22-22.00.47.159003 DBA_TAB_COL_STATISTICS SYSIBMADM V 2012-05-22-22.00.46.934001 DBA_TAB_COMMENTS SYSIBMADM V 2012-05-22-22.00.47.301006 DBA_TAB_PARTITIONS SYSIBMADM V 2012-05-22-22.00.47.401006 DBA_TAB_PRIVS SYSIBMADM V 2012-05-22-22.00.47.526002 DBA_TRIGGERS SYSIBMADM V 2012-05-22-22.00.48.571004 DBA_VIEWS SYSIBMADM V 2012-05-22-22.00.48.479008 DBA_VIEW_COLUMNS SYSIBMADM V 2012-05-22-22.00.48.327001 DBA_ALL_TABLES SYSPUBLIC A 2012-05-22-22.00.47.992003 DBA_ARGUMENTS SYSPUBLIC A 2012-05-22-22.00.44.128000 DBA_CATALOG SYSPUBLIC A 2012-05-22-22.00.44.444003 DBA_COL_COMMENTS SYSPUBLIC A 2012-05-22-22.00.44.678003 DBA_CONSTRAINTS SYSPUBLIC A 2012-05-22-22.00.44.970003 DBA_CONS_COLUMNS SYSPUBLIC A 2012-05-22-22.00.44.870001 DBA_DEPENDENCIES SYSPUBLIC A 2012-05-22-22.00.45.111003 DBA_ERRORS SYSPUBLIC A 2012-05-22-22.00.45.339003 DBA_INDEXES SYSPUBLIC A 2012-05-22-22.00.45.648000 DBA_IND_COLUMNS SYSPUBLIC A 2012-05-22-22.00.45.455003 DBA_IND_PARTITIONS SYSPUBLIC A 2012-05-22-22.00.45.539003 DBA_OBJECTS SYSPUBLIC A 2012-05-22-22.00.45.739003 DBA_PART_INDEXES SYSPUBLIC A 2012-05-22-22.00.45.831003 DBA_PART_KEY_COLUMNS SYSPUBLIC A 2012-05-22-22.00.45.964003 DBA_PART_TABLES SYSPUBLIC A 2012-05-22-22.00.46.042003 DBA_PROCEDURES SYSPUBLIC A 2012-05-22-22.00.46.131003 DBA_ROLES SYSPUBLIC A 2012-05-22-22.00.48.671001 DBA_ROLE_PRIVS SYSPUBLIC A 2012-05-22-22.00.46.233002 DBA_SEQUENCES SYSPUBLIC A 2012-05-22-22.00.46.358002 DBA_SOURCE SYSPUBLIC A 2012-05-22-22.00.46.508003 DBA_SYNONYMS SYSPUBLIC A 2012-05-22-22.00.46.632003 DBA_SYS_PRIVS SYSPUBLIC A 2012-05-22-22.00.46.783003 DBA_TABLES SYSPUBLIC A 2012-05-22-22.00.47.959003 DBA_TABLESPACES SYSPUBLIC A 2012-05-22-22.00.48.284003 DBA_TAB_COLUMNS SYSPUBLIC A 2012-05-22-22.00.47.199003 DBA_TAB_COL_STATISTICS SYSPUBLIC A 2012-05-22-22.00.46.975003 DBA_TAB_COMMENTS SYSPUBLIC A 2012-05-22-22.00.47.350000 DBA_TAB_PARTITIONS SYSPUBLIC A 2012-05-22-22.00.47.442003 DBA_TAB_PRIVS SYSPUBLIC A 2012-05-22-22.00.47.583003 DBA_TRIGGERS SYSPUBLIC A 2012-05-22-22.00.48.592003 DBA_VIEWS SYSPUBLIC A 2012-05-22-22.00.48.515003 DBA_VIEW_COLUMNS SYSPUBLIC A 2012-05-22-22.00.48.368002
添加新评论0 条评论