I am using DB2 on AS400. I am trying to use a variable in a CREATE
TABLE AS statement. However, I am informed that the variable is not a
column of the FROM table... It feels like a scope issue in the SELECT,
but I don't see how. Please help, I hate getting frustrated by

Interesting!  I was going to ask if such a thing existed, but I was pretty
much convinced they did not so I didn't ask.
Looks like with version 9.5 DB2 supports global variables:
"Global variables improve data sharing between SQL statements.

Hi guys, i have also searched for this error and could find some
replies to this problem but none o them worked.
actually I am getting this:
SQL1220N  The database manager shared memory set cannot be allocated.

Some background (sorry for the length of this post):
I have a query in a production environment that is performing badly.
It somehow slipped through our performance test, without anyone
noticing. If I run the query in our test env. I can repeat the bad

Here is several steps before i got the error:
CREATE SEQUENCE SALE_ID
START WITH 1
INCREMENT BY 1

We have a unique issue where a query does a tablescan even though an
index is present. Basically we created a new DB by loading existing
data from a source DB.
The index names and everything else are same in both the DBs. The

Is there a good source for the performance details of Materialized
Query Tables?  I have to worry about how often to refresh them in
UDB.  Yes, I know that  is very vague.

DB2 LUW v8.2 FP 14  Red Hat EL 3.4.6-2
I need to occasionally copy new tables from a test server to a
production server, and I want to automate it..  What makes this
difficult is that the tables sometimes (usually) have auto-generated

I'm facing one strange problem.  We are using DB2 UDB v 8.1.1 FP 9 (64
bit) in AIX.
We are into DW environment.  We have the setup like, if users fetch
the data for the period of last 3 months, it will go and fetch from

My SP  :
create procedure ARUN.CREATE_TABLE(in schema_name varchar(25),
                in tab_name varchar(25),in tgt_schema_name varchar(25), in
tgt_tab_name varchar(25),in tgt_ts_name varchar(25), in tgt_ix_name

There is a significant gap (~ 3.5 minutes) in the time our LOAD
command indicates that the BUILD phase is complete and the time we
have control returned to our script.
I ran the test below on a dedicated system with no other processes

I am trying to create a function that adds 1 to the value in a
hexadecimalcolumn. This function I want to use inside an SQL PL procedure.
I have a table with a column with char(16) for bit data. A 'select hex(col1)
from tab1' may return x'FFF59E344C59684CA17BB105677343BE'. I have ...

Here is my DDL for table EMPLOYEE
CREATE TABLE EMPLOYEE
(EMPNO CHARACTER (00006) NOT NULL
,FIRSTNME VARCHAR (00012) NOT NULL

I'm trying to make the application which use a db2pd facility.
so, I am looking for db2pd api.
where can i find db2pd api ?
thanks for advance.

I'm actually working on the migration of a DB2 unicode db (V8.2 FP 15) from
a Sunfire machine with SunOS (64 bit, Big-endian) to an AIX 5.3 (64-bit,
Big-endian) server located in US. The target server has DB2 V8.2 FP 15
installed and instance name and filesystem user groups ...