I'm doing some test with perl against db2.
Can someone let me know why my code here end up with endless loop.
When I run 'db2 list applications' I can see that it keep on establish
new connection.

I've got a question here regarding locking during a insert/delete.
Consider the following table:
Column a            Column b
1                        A

   I am trying to do a directed DSS query with local bypass.
The steps I use:
1. Fetch the partition map from the server using the admin api
2. Send the partition map and the partition key values to the

I am wondering whether anyone had this issue earlirt. I haven't seen
any posting on this exception.
Here is the scenario: We migrated from Oracle (US7ASCII) database to
DB2 (UTF8) recently. We used db2load util to load all the data (no

Im running UDB 8.1 on windows 2000 on a single processor server which
is mutli threaded. When I run taskmgr.exe it provids two CPU graphs
despite there only being one processor in the server (also provides a
listing of 2 CPUs in the hardware control panel area).

Hi. We use DB2 on the iSeries. There are things that I have been told around
here are not possible which I am now learning are possible. (I have a
background with SQL Server, and the folks around here do green screen
programming with RPG. I am a web programmer, ASP and JSP/Java.) ...

Our company is migrating to V8.1 FP 5 UDB this quarter,from V7.2 FP10.
In my tests I have built new V8 instance and restore V7 database to
it. The db is migrated upon restore automatically and seems to
function normally. Can anyone tell me why I ever have the need to

Hi,
We have a query where if we use an IN() predicate on a FK, the
optimiser cost(and reflected in execution time) is around 1e06,
but,

it is possible to create a ARRAY in DB2 ?
I have read the SQL:1999 standard  have the ARRAY Command.
I have a sample from a book:
CREATE TABLE company

If one uses multiple containers for a single tablespace on a disk array that
has been striped (RAID-5 or RAID-0), does DB2 stripe the tablespace across
the containers, resulting in duplicate striping?
If so, does this hurt performance by causing contention on the disk heads?

Trying to use it in do() context I get the error:
[CDCMS::DBIException] DBD::DB2::db do failed: [IBM][CLI
Driver][DB2/LINUX] SQL0104N An unexpected token "load" was found
following "BEGIN-OF-STATEMENT". Expected tokens may include: "".

Folks,
 I am not sure if this is a perl of DB2 problem. I had posted this
 problem last week but did not get any reply. I am posting it again
 with some more info to see it someone can identiry the problem.

Where in the documentation can I find a syntax summary of the language
supported by SQL procedures? I have found documentation of several
statement types, but I have no idea whether that is the whole language
or not.

When running a DB2 script using the command (for example)
$ db2 -o- -tv -z outfil < chee.sql
the SQL in the input is copied to the output, with the DB2 results added
in place. Is it possible to have -- comment lines also copied into the

is there a possibility (DB2 UDB V7.2) the PACKAGE CACHE to be freed?
Regards / Gruß
----------------------------------
Stefan M. Mihokovic