Hi, all:
I've been an operational DBA in Oracle for about 3 years.
I've been asked to come onto a DB2 deployment project as a project
DBA.

Cant precompile fortran program (sqf) on DB2 on Windows.
db2 prep test.sqf
return "SQL0036N  The syntax of the file name "test.sqf" is not
valid."

Why is it that an Alter statement on a table adding a not null column
gives an error  "SQL0193N" even though the table has no rows.
I guess DB2 should see that since there are no rows in the table, we
can just go ahead and add the not nullable column.

Hello and Welcome to Moviephone!
I have been working in DB2 8.x (on UNIX) for a couple of months now
using Windows as a client machine.  Coming from an Oracle/SQLPlus
world, I have certain expectations of a tool like "Command Editor" -

Please help me to understand the clustering index concept w.r.t to a
partitioned table.
Scenario 1;
On a non-partitioned table Clustering index works fine (as it shows

I have a system where I pull data from an upstream database and then
ftp it through to another database server so I can load it up on
another system.  This gives me several possible points of failure such
as the connection got cut off before the file completely exported.

How can a DB2 stored procedure act as a web services client?  I assume one
could write a Java or C stored procedure to act as the client.  Is there a
way just using SQL PL?
Thanks,

Hello Gurus,
At about 11:00 am this morning, tried to connect to an instance of DB2 UDB v8.
2 fixpak 14 on a Red Hat Linux environment. The message returned say DB2
alias not found. Alarmed, we researched extensively and found that all data

That works faster in DB2 for creation of an index:
CREATE INDEX
or
Alter Table tab ADD INDEX

I was getting the error: sqlcode: -911  sqlstate: 40001 , which is
"The maximum number of lock requests has been reached for the
database."
So i increased the locklist size to 200 from the default value of 100.

Has anyone ever seen this?  Is it of concern?  It looks odd to me
2007-08-20-21.00.19.762042+000 I1661719251E395    LEVEL: Warning
PID     : 9590                 TID  : 47819418342320PROC : db2agent
(instance) 9

Trying to concatenate two fields into one however I seem unable to do
so.
All I want is to execute the following
SELECT MONTH(L.DATE) ||' '|| YEAR(L.DATE) as MTH_OF_YEAR

I am having the following issues while trying to restrict the current
user from creating any objects.
Below is the privileges for the user and response when i try to create
a table in that user.

Is there anyway to figure out when the REORG was run last on a table/
index ? We are using DB2 V 9.x.
Thanks.

 in db2 v9,how long the rid?
 how structure of the rid?
 in a page,what limit of record?
 thank you!