I have some users that have 5 or 6 connections with the same login at
the same time. I want to limit that each user can have less than 3
connectios per login. How can I do that??
Thanks in advance

Hi, Friiends,
I am db2 UDB DBA on aix.

nickname to access the tables on db2/390. For the security ,we can use

I just got an email from Amazon.com offering me a pre-order of "DB2 9 for
Developers" by Philip K. Gunning.  Clicking on the link it showed me a few
other possibly interesting books:
"IBM DB2 9 New Features" by Paul Zikopoulos

Recently I did some DB2 and ODBC coding in Visual FoxPro. I bumped on a
problem I cannot resolve.
When I issue a delete statement that deletes no rows (no rows qualify
for the WHERE conditions), DB2 raises SQL0100W warning with

In Information Center it says;
"Restrictions on database partitions
- The use of any features of the native XML data store will prevent
future use of the database partitioning feature available with DB2

I have a table with 1.000.000 registers and I want to find the
register in a position 25.000. I don't want to use a cursor, how can I
do it in other way?
Thenks in advance

I have two tables that are pretty big.  I need about 10 rows in the
left table and the right table is filtered to 5 rows as well.  It
seems when I join the tables in the FROM clause, I have to filter my
left table in the WHERE clause and cannot filter it in the FROM

v8.2.7 ese, WinXP
I'm trying to catch locktimeout.
1.
I issued:

Does anyone know of a tool that gives a bit more readable info out of
the db2pd tool when executing Locktest? I'm thinking of something that
will show the type of lock and which tables by name rather than by ids
etc.

I have DB2 UTF-8 database (codeset IBM-1252) on Windows 2000 Server. I
need to store multi-byte contents. How do I calculate size of the
column to store multi-byte information?
F.ex: I cant have a column with size VARCHAR(10) bytes to store 10

We have a simple shell script called testsp.sh (located at /home/
userid)
Within the shell script, the following command is called:
db2 -tvf callsp.sql

I am using DB2 in AIX.
I have a master table
and a txn table.
The master table has many many records.

all,
I'd like to know if there is a way (via JCL / TSO command / filesystem
structure
or something other) to get the list of all the db2 subsystems

RedHat has recently released RH Advanced Server 5.0. Will this be a
supported/validated platform for DB2 v8/v9 ? If so, is there an
estimated date for this?
Thanks,

When running VMSTAT 3 5, in provides a snapshot every 3 seconds for 5
intervals.
Is there a way to add date / time as one of the parameters (AIX
environment)?