| View previous topic :: View next topic |
| Author |
Message |
abc2000
Beginner
Joined: 22 Mar 2006
Posts: 18
Topics: 9
|
 Posted: Mon Jul 03, 2006 8:19 am Post subject: db2 how to create database simultaneity ? |
 |
|
db2 how to create database simultaneity ?
I need create a lot of db2 database, if I create database simultaneity,
I get a -911 error
| Code: |
DSNT408I SQLCODE = -911, ERROR: THE CURRENT UNIT OF WORK HAS BEEN ROLLED BACK
DUE TO DEADLOCK OR TIMEOUT. REASON 00C9008E, TYPE OF RESOURCE
00000302, AND RESOURCE NAME DSNDB06 .SYSDBAUT.X'000003'
DSNT418I SQLSTATE = 40001 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXISUB SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -190 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFF42' X'00000000' X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION
---------+---------+---------+---------+---------+---------+---------+---------+
DSNE618I ROLLBACK PERFORMED, SQLCODE IS 0
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0
---------+---------+---------+---------+---------+---------+---------+---------+
|
how to create db2 database simultaneity ? |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12383
Topics: 75
Location: San Jose
|
| Posted: Mon Jul 03, 2006 8:25 am Post subject: |
|
|
| Quote: |
I need create a lot of db2 database, if I create database simultaneity,
|
abc2000,
A lot of database ?  Do you mean create Db2 tables ? 00000302 is a Table space page error. What type of tables are you planning to create?
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
abc2000
Beginner
Joined: 22 Mar 2006
Posts: 18
Topics: 9
|
| Posted: Tue Jul 04, 2006 3:24 am Post subject: |
|
|
WHILE FIRST DB2 datbase create is executing,
if I create second database, report -911 error, probly
DSNDB06 .SYSDBAUT is DB2 system table
probably DB2 system table is locked bye first job |
|
| Back to top |
|
|
abc2000
Beginner
Joined: 22 Mar 2006
Posts: 18
Topics: 9
|
| Posted: Tue Jul 04, 2006 3:26 am Post subject: |
|
|
| abc2000 wrote: | WHILE FIRST DB2 datbase create is executing,
if I create second database, report -911 error,
DSNDB06 .SYSDBAUT is DB2 system table
probably DB2 system table is locked bye first job |
|
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
