Am using Db2 v.8.2 ESE on Win 2003 Server. Am trying to connect to an
already created db. But am getting the following error:
db2 connect to DBNAME
SQL1226N  The maximum number of client connections are already

DB2 LUW 8.1 fixpak 14
Linux Red Hat AS
I'm trying to get the maximum value of a sequence.  Because of the way
the sequence is used (on several tables comprising a fat view), its too

I am looking for the DSNTEP2 sample applications in DSN810.SDSNSAMP
referred to in
the DB2 UDB for z/OS Version 8 Application Programming and SQL Guide
(SC18-7415) (see link below for manual).

Server:   DB2 LUW 9.5 on Solaris 10
Client:    DB2 Data Server Client 9.5  (= Control Center) on a Win XP
SP2
Problems:

We have some trouble with C-written application and UDF on 64-bit
Windows ...
Given the following production environment:
- Windows 2003 Server on AMD64

Does PureXML use bufferpools for all the data stored?
I am assuming that PureXML is faster than XML Extender at shredding data,
but is not faster than relational (without LOB's) in cases where there are
no XML documents (other than people trying to force a schema into an XML

I have a procedure that is getting -443 after upgrading to V9.5 FP1.
The procedure was written to output only the SQLCODE.  Here is the
output that is returned:
Value of output parameters

I'm DB2 newbie.  I need to remove large number of rows from a table.
I don't want to fill up the transaction log space.  I have the below
SQL that I feed to the db2 command to repeatly remove a fixed set of
rows until there is no more to remove.  However db2 complains about

Does a java program treat a DB2 column defined as SMALLINT any different
than INT?
In other words, if I changed a column from INT to SMALLINT, would that
require any java coding change?

I have all the library already in path:
$  ls -l /opt/IBM/db2/lib64 | grep libdb2o
-r-xr-xr-x    1 bin      bin         7757295 Jul 12 2006  libdb2osse.a*
-r--r--r--    1 bin      bin          227313 Jul 12 2006  libdb2osse_db2.a

I would like to write script to query "select * from xxx where date =
yesterday" result output to text file daily .
By select data of yesterday. please advise me thank.
Regards,

I have a CTE and it is working fine.
WITH TEMP(CLAIM_TYPE) AS
(SELECT DISTINCT CLAIM_TYPE FROM CLAIM_ERRORS ORDER BY 1
 FETCH FIRST 4 ROWS ONLY),

I have a query in Oracle like this:
Select 1 from dual
where
(1,1) IN ( (1,1), (2,1) )

What can we do about these non-topic postings to this group?
Fully one-half of the postings are non-DB2 related.
-B

Just wondering, is there any way to do the online reorg to use
temporary tablespace instead of tablespace table existed.
since that is really a waste to have some space allocated aside only
for the online reorg ..