PID     : 7031                 TID  : 3007211424  PROC : db2start
INSTANCE: db2inst8             NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloPdbFreeCmdHandle, probe:10
MESSAGE : Error closing socket, OSSrc =

By mistake, posted in informix group..Here it is now...
On Windows:
In db abc:
1. create wrapper drda

db2 version 6.1 (Sun Solaris 7)
when i try to update use the FixPak 11 db2admin start, it will hang..
why this will happen.. and what should i do to solve this problem??
ps: Help!!!

we are using db2 udb v8.2 on windows. all our tables are created with
not logged initially property,
So if i want to activate HADR (high availability disaster recovery) for
the database, in the document it said " non-replicated operations

Or you pretty much have to backup the databases on the instance. Drop
it. Create another instance with a new name. Restore redirect the
backed up database onto the new instance.
Bill

I have a SQL statement that access to one database (DB2) i.e.
SELECT
 DB1.TABLE1.TABLE1_ID,
 DB1.TABLE1.FIELD_A,

Hi
  I try to delete a column of the table but AIX - WIN db2
did not allow me to do this
    ALTER TABLE  table_name  DROP COLUMN   column_name

I am trying to test out the automatic maintanance with notification
feature of DB2 v8.2. I have enabled the auto maint with notification.
The problem I am facing is that I only get email notifications from DB2
when there is an alarm as follows:

i would like to do a db2 class set (net win2k).. i wanna do that because
of i have two server and if one of the server is "system down", and the
other one can take over.. so, what i'm going to do?
ps give me the solution..

I need to know what's wrong in this translation from Informix. Note the
difference in the results, which is due to the UPDATE statement.
ORIGINAL PROGRAM (INFORMIX):
---------------------------

During the installation I get these error messages:
*****
SQL1390C  The environment variable DB2Instance is not defined or is
invalid

I want to set the transaction lock timeout, i.e., 'set current lock
timeout X', but before that I want to see if it is already set and what
the value is.
How can I retrieve this from the CLP?

US- MN - Functional Oracle Consultants
Salary: Your Best,
Start Date: Immediate,
Duration: April 4, 2005 - Jan 6, 2006

is it possible to connect to a DB2 database through PHP WITHOUT ODBC like in MySQL?
Example MySQL:
  // Open the database connection and use the sample
  // database

I want to extract one row from each range data.
For example , we had table had following data
name    age    department
janet   22     HR