I tried to compile a stored procedure on DB2 v7.0   on Solaris.
The procedure is very simple as below:
CREATE PROCEDURE fullamount(OUT fullamnt DOUBLE)
language SQL

I'm getting an SQL3193N on DB2 v8 (fixpak 11)...
SQL3193N The specified view or materialized query table cannot be
updated.  You cannot LOAD/IMPORT into this view or LOAD into this
materialized query table.

DB2 UDB supports automatic storage management in v8.2.2 and v9. The
question is how do I know the databases and/or tablespaces are enable
"automatic storage management" or not after created for a period of
time?

Does connection concentroator only support in DRDA environment?
Thanks in advance,
Laurence

I need to know the Network Stack used by IBM DB2 when connecting to a
remote data base.Also If any one is aware of the details of packet
structure / format during the conversation between the remote client
and server.

We currently have DB/2 8.1 running on z/OS 1.5.  I need to move it to
DB/2 8.1 on z/OS 1.8.  Not knowing much about DB/2 admin, I'm at a
loss as where to start.
Can someone point me to a resource that will help migrate a DB/2

A client has 390/V7 and UDB/V8.  It would be useful to use row_number()
when selecting from 390, but that's not supported.  It occurs to me (I'm
not in CubeLand, and anyway we upgraded to V8 on z/OS) that federation
(on UDB/V8) might support functions on those 390/V7 tables.  Is ...

Ive installed db2 V8.1 FP11. when i run a local connection, it
connects correctly. However when i run a remote connect (using
squirel) it gives a connection refused error.
i ran a tcpdump on the port (60000) whicle attempting to connect and i

I have a large union.
If I break it into its individual parts they all run quick.  The
longest is the last select it takes 2 minutes to fetch all rows. When
I run the query below it does not come back for quite some time. 20

I was getting snapshot since the database was responding very
slow...here is the query that was in a snapshot:
WITH TYPEINTS ( TYPEINT, COLTYPE ) AS (  VALUES  ( SMALLINT(1 ),
CHAR( 'INTEGER',  8) ),  ( SMALLINT

I am a little puzzled.. I am trying to make some insert into an DB2
using SQLEXEC and it just does not work...
code looks like that:
/*

DB2 LUW v8.2 FP 14  RHAS 2.1
Sorry if these are newbie questions.  Optimizer stuff is black magic
to me.  For both of these, assume stats are current and an even
distribution of data.

I need to downgrade a DB2 database from 8.2(AIX) to 7.1(Windows).
Are there any issue in doing so?
Why I need to do this?
In order use "Oracle Migration Work Bench" that supports only DB2 7.1

  Everyone looks at some 5 parameters if they are going to deal with
db performance, like the sortheap, stmt heap, appl heap etc. I just
have one small doubt(big it may be).. If I give a value of say 64000 -
4k pages to sortheap, does it mean I am giving  256 megs for the db as

We have a Test Database in Linux with DB2 v8.2.
DB2 was installed in /db2home/db2inst1.
Some one moved the all folder db2inst1 to Trash. I moved it back to
db2home/db2inst1