CREATE REGULAR TABLESPACE TBSP32K0000 IN DATABASE PARTITION GROUP
IBMCATGROUP PAGESIZE 32768 MANAGED BY SYSTEM
USING ('C:\DPF\NODE0000\SQL00001\TBSP32K0000') ON DBPARTITIONNUMS
(0)
EXTENTSIZE 32
PREFETCHSIZE AUTOMATIC
BUFFERPOOL BP32K0000
OVERHEAD 12.670000
TRANSFERRATE 0.180000
DROPPED TABLE RECOVERY ON;
CREATE TEMPORARY TABLESPACE TBSP32KTMP0000 IN DATABASE PARTITION GROUP
IBMTEMPGROUP PAGESIZE 32768 MANAGED BY SYSTEM
USING ('C:\DPF\NODE0000\SQL00001\TBSP32KTMP0000') ON DBPARTITIONNUMS
(0)
USING ('C:\DPF\NODE0001\SQL00001\TBSP32KTMP0000') ON DBPARTITIONNUMS
(1)
EXTENTSIZE 32
PREFETCHSIZE AUTOMATIC
BUFFERPOOL BP32K0000
OVERHEAD 12.670000
TRANSFERRATE 0.180000;
"Levy Alex "
<db2udbdba-ezmlms
hield-x56122642.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
12/29/2005 10:37
AM Subject
RE: Tools Catalog
Dan
I've created the tablespace just on the catalog partition, and when that
failed with the error message below, recreated it on all partitions.
The db2look confirms containers on each partition. But you get this error
message from whichever partition you choose to issue the create tools
catalog command (with the use existing tablespace and database option).
Should the tablespace exist on the catalog partition only?
If you first export DB2NODE=0 then let the command create a tablespace for
you in an existing database, it does places the new tablespace on the
catalog partition only; thereafter it fails with:
=> db2 create tools catalog toolscat use existing database test
SQL0443N Routine "" (specific name "") has returned an error SQLSTATE with
diagnostic text "".
Useful - the db2diag.log gives
2005-12-29-15.29.32.427256+000 I2939481A297 LEVEL: Error
PID : 983148 TID : 258
FUNCTION: DB2 Tools, DB2 administration server, writeICMErrorMsg, probe:10
DATA #1 : String, 90 bytes
ICM0901N An SQL error occurred while creating the Information Catalog
Manager API tables.
2005-12-29-15.29.32.427451+000 I2939779A386 LEVEL: Error
PID : 983148 TID : 258
FUNCTION: DB2 Tools, DB2 administration server, writeICMErrorMsg, probe:10
DATA #1 : String, 178 bytes
[IBM][CLI Driver][DB2/AIX64] SQL0443N Routine "SYSIBM.SQLTABLES" (specific
name "TABLES") has returned
an error SQLSTATE with diagnostic text "SYSIBM:CLI:-727". SQLSTATE=38553
None of these codes narrow it down much. But it does kingd of suggest tools
catalogs and DPF were not meant to be, at least at this release. Any
suggestions welcome!
Regards
Alex
-----Original Message-----
From: DANIEL CALLAHAN
[mailto:db2udbdba-ezmlmshield-x19139001.[Email address protected]
Sent: 26 December 2005 20:34
To: LazyDBA Discussion
Subject: Re: Tools Catalog
Can you issue a db2look for the tablespace and do a list tablespaces on
each node. It should be possible, what about just connecting to
the co-ord node and issue it without the db2_all ? Im not
sure why you
would need to specify the db2_all.
"Levy Alex "
<db2udbdba-ezmlms
hield-x15804840.x
To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address
protected]
cc
12/23/2005 06:16
AM
Subject
Tools Catalog
Dear All
We've covered all the gotchas in the Command Reference, but
cannot create a
tools catalog on an existing, partitioned database. The
documentation does
not mention a limitation, but can anyone confirm that it is
only possible
to
create a tools catalog on an existing database if it is single
partition?
When we attempt to run:
db2_all "<<+0< db2 connect to test; db2 create tools catalog
toolscat use
existing tablespace tools32kts000 in database test; db2 terminate" the
server returns:
SQL0670N The row length of the table exceeded a limit of "0" bytes.
(Tablespace "TOOLS32KTS000".) SQLSTATE=54010
Now this tablespace is defined as 32k pagesize, is in a normal
state and we
are able to create tables in it.
The instance owner is attempting to run this directly at the
server on a
local partitioned database and is a member of the DASADM_GROUP. The 32k
temporary tablespace is also in place and the admin cfg
JDK_64_PATH is set.
Season's Greetings,
Alex
******************************************************
The information in this E-mail and in any attachment is
confidential and is intended solely for the addressee.
Access, copying, disclosure or use of such information
by anyone else is unauthorised. If you are not the
intended recipient please contact [Email address protected]
While reasonable efforts are made to ensure these files are free
of virus infection and offensive materials, if something of this
nature is inadvertently sent to you, please destroy it, accept
our apologies and contact [Email address protected] with
details of the sender. We will ensure that action is taken
immediately to prevent any recurrence. Debenhams accept no
responsibility for any views expressed by the originator of this email.
Debenhams Retail plc (reg. no. 83395) Registered in England and Wales.
Registered office: 1 Welbeck Street, London W1G 0AA.
http://www.debenhams.com
******************************************************
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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