Hi, Friends,

default DB2 compression library.
I am wondering if this option will have any new restriction on RESTORE

I need to disable some DBM Monitor Switches but I am not able to do
this
Someone knows why this is happening?
renan[/db2util/db2inst1]$  db2 get dbm monitor switches

Is there a way to limit the number of rows in a table?  Lets say I
want to only allow 1000 records to be inserted into a table.  Can I
CREATE or ALTER TABLE and set it to only allow a max 1000 record ?  I
did not see the option available under either of these.

If someone can clarify this, it would be of great help!
We have a merge, which is written *only* to update the target table.
but the access plan shows branches with inserts and deletes on target
table. On top of it, the application snapshot monitor shows "Rows

Is there any way to  restore the backup of DB2 Express C 9.0 edition
on a DB2 Server that have
DB2 Express edition Version 8.2.
Or atleast any workaround method???

I have been building a set of tables for a new database and having
problem with tables having columns defined as Long Varchar. Can
someone look this over and tell me what I am doing wrong with the
create statement shown below:

        I have a file to load and it contains every printable
character, does anybody knows how to put a nonprintable character as
the chardel ? . Thanks

How can we distinguish sequnetial vs random IOs in db2. IS there any
kind of db2 or OS level monitoring that can help in this regard ?  I am
running db2 on windows.
thanks

Hi there, can any one help me? I am new to DB2 sql, I will be using
the case statement to make comparisons in the select but I cannot get
it to work. The query below is an example of the comaprison I am tring
to do, it is not returning any rows. The column qactdat is a numeric

Is there any method available in DB2 V8 to retrieve only the Warning
or Severity messages from the notification log ?
PS: I'm looking for something similar to PD_GET_DIAG_HIST function
available on DB2 Viper 2.

All my SPs have an SQLSTATE OUT parameter.  However, working with MS
VB6 ADO, parameters IN have no problem, but SQLSTATE parameter OUT (in
the procedure) always returns empty.  Reviewing the COMMAND object
shows that it does have an P_SQLSTATE parameter, (that's what it's

Hi group,
I am going through some exercises regarding DB2 Administration and I
found the below:
How many extents are allocated when the following Employee table is

How can i estimate the approximate size of the database as a whole.
This is required because i want to take the backup of the database and
have to make sure that that much space is available.
Thanks

I've got about a dozen new staff that need query access to an existing
database (db2 ese v9 on aix).  They'll probably be using brio, and
aren't covered by my existing db2 licensing environment.
I'd prefer for them to use the db2 v9 client - since that provides a

I've been working with db2 8.2fp14 for over a year now and was
wondering what is a "standard" way of doing a backup to provide 24/7
operations with disaster recovery capabilities?
My thoughts were an offline backup once per quarter, followed by a