Some may find this utter madness some may be ridiculed. But I have a
doubt.
I have one table arun.test1 ( icn varchar(20), icn_sub varchar
(20)............)

Faced strange thing in DB2 9.5.
I just noticed that TIMESTAMP(GENERATE_UNIQUE()) returns timestamps in
April 24 while current time on computer is April 27 !
It is virtual machine under VmWare with Windows Server 2003 SP2 and

Is there a SQL query to retrieve server full hostname or IP address.
Something like
select current server as server from sysibm.sysdummy1
Thanks.

db2pd -mempools -alldatabases -inst
=> Sum of PhsSz = 9GB
db2pd -memsets -alldatabases -inst
=> Sum of Used = 9GB

Hello, I want to know few things about express-C. Does it support any
parallelism,since if you have 2 processor support and no query
parallelism..what can it do? can it build index parallel or collect
statistics like that. utilities/IO?

Hi everyone, I am a software developer looking at database solutions.
I presently make use of Microsoft Access for a lot of things, but am
beginning a project that requires the database to be networked and for
a number of users to have concurrent access.  It sounds like DB2

We run a web based service with db2 as the data storage mechanism. What
we would like to do is locate a hot standby machine in another state
with automatic fail over. There are lots of problems in configuring such
a system, but what really has me stumped is the database ...

 I need automatic conversion of types like those of Informix, Oracle
and SQLServer where sentences like
 SELECT * FROM MYTABLE WHERE MYTABLE.ONEFIELD='89'
 are executed without any kind of problems. The type of the column

In V9.1 according to the documentation, the online backup is
compatible with DDLs that require a Z lock (such as ALTER
TABLE,...)... Online DMS table space backup is compatible with DDLs
that require a Z lock.

I ran a load and it crashed in the middle of index rebuild due to
unavailability of free space in file system. I terminated it, and on
simple query it gets a super-ex  Z lock. I know the index is getting
rebuilt. Is there a way, like 'inspect check' would get me

I ran these statements and expected that the snapshot for dynamic sql
would return nothing.  Why am I getting data in the datamart.out file?
db2 reset monitor for db datamart
db2 flush package cache dynamic

I want to know if there is a way to find out the least size of
bufferpool while maintaining high hit ratios.
please advise.

I have DB2 95 with fixpack 3b installed on Windows 2003 R2 Server 64bit.
When I try IMPORT command with a DEL or ASC options I get:
SQL3015N  An SQL error "-804" occurred during processing.
SQL0804N  The application program parameters for the current request are not

When acquiring a User-Count based DB2 EE license, minimal 25 users
have to be purchased.
How does it relates to sub-capacity licensingm can these users be
spread-out between different LPars (dedicated,capped, uncappped)?

Faced quite strange behaviour of DB2 9.5.
By "CREATE DATABASE" statement it allocated 2.1Gb on disk.
Looks a bit crazy - it is just an empty database - still nothing
created thata - no tables, no objects.