All:
This is becoming a big problem for us. Whenever we are using control
center it asks for the userid/passwd and when we provide the admin
userid/passwd we get a error

I have a table with a column as identity. I don't know how can migrate a
identity column to a normal column using sequence.
Thnaks

I have all the scrips to create a database. I have a few questions:
1- I am creating a batch file that it will call many lines like:
       db2 -td@ -f filename.sql -z output.txt
The order i am using is:

Since V8.2 does not require a C compiler to build SQL stored
procedures, I am just wonderring how they are now implemented internaly
as opposed to C embedded SQL before V8.2, so, basicaly, what happens by
CREATE PROCEDURE LANGUAGE SQL statement (I noticed no C files get

I appreciate if anyone can help me out, please.  I have two tables;
TableA and TableB.  When the user enters the account, I match it
against TableA.col1.  Then I get the TableA.col2 from TableA and match
against TableB.col1.  If not found, I still want the record to show.

Hi,any one know ,in DRDA enviroment DB27.1 running in ZOS/E,I find when
apllication program access DB2 through DB2connect ,in mainframe two address
space TCPIP and DIST CPU usage were very high ,and DBM1 or MSTR address are
low,one sample maybe 15%(tcpip),10%(DIST),1%(DBM1),we are ...

We have UDB 8.2 on Windows and we want it to be migrated to V8 of DB2
on Mainframe.
1. Can a SQL FUNCTION contains SELECT statements in RETURN Clause in
Mainframe? below function compiles in UDB.. Will it compile on

I am trying to write a trigger/UDF combination that closely follows the
example given in the following DeveloperWorks article:
http://www-106.ibm.com/developerworks/db2/library/techarticle/0205bhogal/0205bho
gal.html
Unfortunately, when my UDF starts to compose the email, something ...

I am trying to figure out if a UDF can accept a UDT (User-defined Distinct
Type, *not* structured type) as one of its parameters. I'm running DB2 for
Linux, Unix, and Windows V8.2 (FP 8) on Windows XP.
For instance, let's say I have two UDTs, ShoesizeEuropean and

Hi team
Is there any easy way to Import PostGRESQL 7.2 which is on the Linux
mechine to a DB2 UDB 7.2 on WIndows. What Options do i have.
Thanks

I am migrating from AIX to Linux DB2 7.2  During cleanup I deleted an
active log file.  I am on log1540 and it says log 1541 is missing.  It is.
I do not need any of the data, I can re-import.  But I cannot connect.
I have no backups yet.

I had many troubles of finding a company who provides Remote Database
Administration. I reviewed quite a lot of services and finally got to
know about a company who has done some work and are kind of supporting
enterprise customers with their huge databases. I dont wanted to

I am trying to create a stored procedure that accepts 3 parameters.
Using these parameters I am joining on 2 tables and a UDF that accepts
these 3 parameters to get movement information. When I try to pass
these parameters in the function for each parameter I get and SQL0206

I have been researching ADO.NET in order to train our programming
staff.  I am curious if someone would know what the default isolation
level is with and without a transaction.  Furthermore, if I specify the
isolation level on the transaction object, which one is the most like

Hi,
We are investigating the possible platform options for going to 64-bit ?
Can anybody offer any links &or Judgements on the relative
merits of DB2 64bit on AIX and DB2 64bit on OpenPower(Linux) ??