I just created a new user and granted connect and select on a single
view, only. When I connect to my database, the new user has at least
select privileges on the whole database. What am I doing wrong or
misunderstanding? How do I discover all the privileges granted on my

Is there a way (database parameter?) to set a default isolation level (
meaning UR!) for all dynamic sql run against the database? I know the
command set current isolation, but as I understand this have to be set every
time a connection is made. What I'm after is a way to change ...

Hello, I have a requirement to delete millions of rows from a table
which has billions of rows. Hence I have coded a korn script to delete
rows recursively and with a commit interval of 10000. However I feel
that the delete is taking some time to delete, hence would it be a good

I am able to connect to a Z/OS thru an AIX gateway, but when I try to do
select 1 from sysibm.sysdummy1
I get the following error:
[IBM][CLI Driver][DB2] SQL0551N  "AOPSXS" does not have the

I have installed DB2 8 on a VMWare image. All good so far. Then I made
a copy of that VMWare image, gave it a new name and hey presto, new
machine. Problem: on the new VM, DB2 still thinks it is the original
machine. That is, in Control Center under the "All Systems" node, it

I am new to DB2. I am getting this error while loading the DB2Driver. I
don't have any idea about where i might have gone wrong. please help
me.
Below is the stack trace.

hi...I am very new to DB2 Cube views, I worked with MS Analyis services
earlier and this is new assignment for me to work with DB2 Cube views, Can
I get any help regarding this..........Is  DB2 Cube views(ROLAP MOLAP or
HOLAP storage) and does MDX work with DB2 cube views?

I am connecting to a linux based db2 v8.1.9. I want to use CLIENT USERID
in my views to perform data restriction. Unfortunately it not set inside
an ODBC session, a client CLI session or a server session. All three
return blank as the result even though the userid is available ...

Hi All;
We have many production jobs that "load from cursor" to a UDB/AIX 8.2
(with dpf) data warehouse from source tables residing Oracle 9i. Since
Oracle dates are (roughly) equivalent to DB2 timestamps, we frequently

Can someone confirm that DB2 UDB v8.1.2 does  NOT support internal
procedures as supported by Oracle? For example, this would work in
Oracle, but not in DB2. Am I correct?
CREATE OR REPLACE PROCEDURE TPROC1()

i am much confused about buying data base administration book for db2.
will u plz suggest me which book should i buy
for both db2 adminstrative guide  for windows  as well as db2
adminstrative guide for iseries

I'm a new beginner of DB2. I face 2 question during restore the data.
I have 2 DB2 servers on my company. Server A is running on V7.2 and
Server B is running on v8.2 (Enterprise Server). I backup a database
from Server A and restore it on Server B.

Please let me know , what are the various impacts on migrating UDB DB2
8.1 to Mainframes.
Thanks
Vijay.T

Our production DB2 installation does not have the TOOLSDB, without this
I cannot do any scheduled task using the task center. So can you guys,
please help me in how to install the TOOLSDB in the production server?
Regards

On 1 machine the installation works perfectly with one of the first
installations screens being the one with the Typical installation taking
520-590MB. (http://users.telenet.be/vibbe/db2-fine.JPG)
But on about 5 other machines i wanna do exactly the same, but then i get