It's probably the locked out because of the statistics creation. The
compute statistics clause will put locks on the system tables where the
statistics are stored. You could try loading the small table without
computing statistics? Then runstats on the small table when the large table
is fully loaded.
"Kevin Knaus "
<db2udbdba-ezmlms
hield-x67220260.x To
[Email Address Removed] "LazyDBA Discussion"
A.com> <[Email address protected]
cc
26/10/2005 04:00
Subject
does an index creation with compute
statistics block other tables
from being loaded
I am running an index creation against a large table (1billion rows) and
am using the compute statistics clause in the index creation statement.
On another table I began a LOAD. It is a very small table, maybe 700
rows. But, the LOAD is just waiting.
Do index creations block loads even if separate tables are involved?
This is not a cursor load in case some of you are wondering?
Thanks,
Kevin Knaus
CMS Direct UDB Dba
651-604-2371Office
715-664-8890 Home Office
-----Original Message-----
From: botlhaleb
[mailto:db2udbdba-ezmlmshield-x76776510.[Email address protected]
Sent: Tuesday, October 25, 2005 8:42 AM
To: LazyDBA Discussion
Subject: CCI Error
Hi Gurus,
Please explain to me the meaning of CCI Error.....running AIX Unix 5.2.5
db2 v8.1 fixpack 6
2005-10-25-05.00.53.152408 Instance:db2aprd2 Node:000
PID:262800(db2tcpcm 0) TID:1 Appid:none
common communication sqlcctcpconnmgr_child Probe:117
DIA3219I Client connecting from IP address = "10.6.17.40", port =
"62562".
2005-10-25-05.00.57.219731 Instance:db2aprd2 Node:000
PID:171524(db2bp) TID:1 Appid:none
DRDA Communication Manager sqljcReceive Probe:30
CCI Error:
0x2FF22478 : 0x00000047 ...G
2005-10-25-05.00.57.227920 Instance:db2aprd2 Node:000
PID:171524(db2bp) TID:1 Appid:none
DRDA Communication Manager sqljcReceive Probe:30
DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x8136001C".
Regards
Felicity
___________________________________________________________
Important Notice:
Authorised Financial Services Provider
Important restrictions, qualifications and disclaimers
("the Disclaimer") apply to this email. To read this click on the
following address or copy into your Internet browser:
http://www.absa.co.za/disclaimer
The Disclaimer forms part of the content of this email in terms of
section 11 of the Electronic Communications and Transactions
Act, 25 of 2002.
If you are unable to access the Disclaimer, send a blank e-mail
to [Email address protected] and we will send you a copy of the
Disclaimer.
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page