DB2 的硬伤 数据一致性读

*****************
data consistency
*****************
session I

C:\Program Files\IBM\SQLLIB\BIN>db2 +c
(c) Copyright IBM Corporation 1993,2007
Command Line Processor for DB2 Client 9.5.0

You can issue database manager commands and SQL statements from the command
prompt. For example:
    db2 => connect to sample
    db2 => bind sample.bnd

For general help, type: ?.
For command help, type: ? command, where command can be
the first few keywords of a database manager command. For example:
 ? CATALOG DATABASE for help on the CATALOG DATABASE command
 ? CATALOG          for help on all of the CATALOG commands.

To exit db2 interactive mode, type QUIT at the command prompt. Outside
interactive mode, all commands must be prefixed with 'db2'.
To list the current command option settings, type LIST COMMAND OPTIONS.

For more detailed help, refer to the Online Reference Manual.

db2 => connect

   Database Connection Information

 Database server        = DB2/NT 9.5.0
 SQL authorization ID   = GAOCHANG
 Local database alias   = GS_DB

db2 => insert into test values('aaaaa')
DB20000I  The SQL command completed successfully.
db2 =>
db2 => select count(*) from test

1
-----------
          5

  1 record(s) selected.

db2 =>



session II :

C:\Program Files\IBM\SQLLIB\BIN>db2
(c) Copyright IBM Corporation 1993,2007
Command Line Processor for DB2 Client 9.5.0

You can issue database manager commands and SQL statements from the command
prompt. For example:
    db2 => connect to sample
    db2 => bind sample.bnd

For general help, type: ?.
For command help, type: ? command, where command can be
the first few keywords of a database manager command. For example:
 ? CATALOG DATABASE for help on the CATALOG DATABASE command
 ? CATALOG          for help on all of the CATALOG commands.

To exit db2 interactive mode, type QUIT at the command prompt. Outside
interactive mode, all commands must be prefixed with 'db2'.
To list the current command option settings, type LIST COMMAND OPTIONS.

For more detailed help, refer to the Online Reference Manual.

db2 => connect

   Database Connection Information

 Database server        = DB2/NT 9.5.0
 SQL authorization ID   = GAOCHANG
 Local database alias   = GS_DB

db2 => select count(*) from test

(hanging at here UNTIL session I execut "commit" or "rollback")


session III
db2 => select count(*) from test with ur

1
-----------
          5

  1 record(s) selected.

db2 =>




session I:
db2 => commit
DB20000I  The SQL command completed successfully.
db2 =>

session II:

db2 => commit
DB20000I  The SQL command completed successfully.
db2 =>

 

??????????,control center ?????? ??CLP????????,??gaochang ??schema.
db2 => select schemaname,owner from syscat.schemata where schemaname='GAOCHANG'

SCHEMANAME
                                                 OWNER


--------------------------------------------------------------------------------
------------------------------------------------ -------------------------------
--------------------------------------------------------------------------------
-----------------
GAOCHANG
                                                 SYSIBM



  1 record(s) selected.

db2 =>

??schema ??????! ???test ????,schema ?db2 ?????
?????gaochang ??schema ?,?control center ??????gaochang??schema, ???? TEST ?!
??control center ,??control center ?,????gaochang ? test .

??:
1, db2 ??????????,???????????????????db2 +c?????????,??????????????
? with ur ??????????????????
2, control center ??????oracle oem?
====================================================================================

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11976525/viewspace-673083/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/11976525/viewspace-673083/