I am in the process of loading tables, One which I had to restart and the
status is showing "BLOCK", what does that mean????
CONNECT Auth Id Application Name Appl. Application
Id Seq# Number of Coordinating DB Coordinator Status
Status Change Time DB Name DB Path
Handle Agents
partition number pid/thread
------------------------------ -------------------- ----------
------------------------------ ---- ---------- ----------------
--------------- ------------------------------ --------------------------
-------- --------------------
USERID1 db2bp 54
*LOCAL.USERID1.051230151333 0036 1 0 16051 UOW
Waiting Not Collected DBdba01
/db/data/udb/data/USERID1/NODE0000/SQL00001/
USERID db2bp 52
*LOCAL.USERID1.051230150356 0005 1 0 1330 UOW
Waiting Not Collected DBdba01
/db/data/udb/data/USERID1/NODE0000/SQL00001/
USERID db2bp 51
*LOCAL.USERID1.051230150317 0006 1 0 1331
Performing a Load Not Collected DBdba01
/db/data/udb/data/USERID1/NODE0000/SQL00001/
USERID db2bp 15
*LOCAL.USERID1.051229224710 0002 1 0 12292
Performing a Load Not Collected DBdba01
/db/data/udb/data/USERID1/NODE0000/SQL00001/
USERID db2bp 10
*LOCAL.USERID1.051229221033 0004 1 0 4832 Block
Not Collected DBdba01
/db/data/udb/data/USERID1/NODE0000/SQL00001/
[Email Address Removed]
___________________________________
Joseph W. McGuire
Distributed Database Management, DTCC
55 Water Street, 19th floor
New York, NY 10041
Voice: 212.855.1068
Pager: 888.397.8143
DB2 & UDB email list listserv db2-l LazyDBA home page