Hi
Something bizarrae is happening in my db2 udb on aix 8.1.4 database.
I deleted all data from a particular database and to reclaim empty
pages I have reorg'd and runstated all tables in this tablespace.

For some reason when I try to do practically anything with the Control
Center I get an error saying the administration server is not active.
However when I run the command db2admin start. It says it is already
active ?.

I'm getting a:
"SQLSTATE" is not valid in the context where it is used.
This is in a stored procedure when I try to a:
 FETCH FROM customerids_cursor INTO v_MYVAR1,v_MYVAR2, v_MYVAR3,

just a quick (maybe stupid) question ..
Can be possible to link a table dynamically using this logic?:
--@@@ SQL START
SELECT Value as myvar, m.field1,m.field2,m.field3 FROM

ok getting a little miffed here. What in specific do I need to be able
to compile and run stored procedures in version 8.1/WIN2k? I have a
developer using Stored procedure builder who when he has created a
stored procedure and compiles it gets a -7032n with it saying it can

How do I create and return user defined data types in DB2.
F.ex
In Oracle I can create a user define datatype and return this data
type from stored function. How can I do the same in DB2?

I need to backup database and then restore it from file on other computer.
I'm using DB2 on Windows XP.
Please give me two simple SQL statements which I could use in Command
Centre.

Has anybody tried using compression APIs given in DB2 8.1 FP4? I would
like to get more info on that. If you haven't tried it, but have some
documentation about its usage, then please let me know about it as
well.

Is it possible to create a sorted primary key in DB/2 and if so, what is the
SQL script syntax for that?
I need it to convert a Topspeed (Clarion) database into DB/2: they use
sorted primary keys. I have written a tool that imports the Clarion

I looking for a tool or function or script who can generated DB2 DDL
tablespaces with datafile on AIX. (I known DB2LOOK and the function
doesn't generated the DB2 DDL tablespaces with DATAFILE). Who can help
me....

Hi Listers,
I need your advice on how to implement our change management
procedures for the databases that we have through CA ERwin.
We have 5 environments (Test,Integ,Prep,Educ,Prod) and all objects are

Hi every,
Which version of DB2 (Work group Or Enterprise) can I use as a stanby
server?
Under Window Do I need Windows server enterprise version?

I need to sync a DB on a remote computer for disaster recovery
purposes only. Because of its dimension I thought to use only
daily (for ex.) Incremental Delta backups. How reliable is this
solution? Do I need to perform a full backup/restore from time

I was wondering if there was a way to create a copy of a table in a
single SQL statement, together with its column structure and data.  In
Oracle, there is a "CREATE TABLE new-table AS select-statement" that I
can use to accomplish this.

we are using db2 udb v8.1 on windows 64bit, somehow , there are two
database being used under one instance, somehow, service db2sysc CPU
takes up to 70%, but the memory use about 1/3 only. and the
application is slow down. so what kind of process is taking the cpu ?