I have a Parts Table with the following structure..
I need to decide which makes the primary key of the table.
I cant have any sequences nor can I add any new fields in this Table.
Table Structure ::

we have a weird issue..
When we try to do select count(*)  from a table..say tab_a.. we get
back the count.
but the moment we try to do "select * from tab_a" ...the instance

Does anybody have any experience with DB2 on NetApp Filer using NFS? I
am reading the documentation that it suggests to mount the data volumn
to: [StorageSystemName]:[VolName] [MountPoint] nfs hard,
rw,nointr,rsize=32768,wsize=32768,bg,vers=3,tcp 0 0

Hi,
In SQL can I do a SELECT on two tables to do a REPLACE on one of them?
How can I differentiate between an opening quotation mark and a closin
quotation mark? I want to REPLACE an Opening Quote with a "<" and

Hi group,
I have a table say with 10000 records and 10 columns initially, I
created an index say i1, after few days I altered the table by adding
10 new columns and 90000 rows of records summing up to 100000 records.

when i tried to create buffer pool in production
The buffer pool operation (CREATE/ALTER) will not take effect until
the next database startup due to insufficient memory.  SQLSTATE=01657
and when I re-start database i am getting

Hi There, We have an issue on our db2 restores. We do database dumps
every night, and restore them to development servers every morning.
This works fine with no errors. However if we backup those images to
tape using Veritas netbackup, and then restore those images and try to

For a specific database, how do I give db drop privelege to a user and
a group?
Regards,
Jatinder

I am trying to create stored procedures but I get an error
[IBM][CLI Driver][DB2/6000] SQL10013N  The specified library "db2udp"
could not be loaded.  SQLSTATE=42724
1. How would I find out the type of the client installed in AIX ?

 I find the "snapshot for dynamic sql" a great tool for identifying
the most frequently executed dynamic sql statements, most cpu used,
etc.  It is a great help for system tuning.  My understanding is it
does not display static sql statements.  Is a statement event monitor

Guys,
Got a DB2 ver. 8.2 on Windows 2003 with four tablespaces (some field size around varchar(2000 on it) define on it. Try to create another database on another Windows 2003 server using db2move export/import, and I got this message.  
SQL0286N  A default table space could not be ...

Can a group be made an owner of different db2 objects, like tables,
views etc?
if yes, then can I use trasnfer ownership to trsfer ownership to a
group?

How to add views from database explorer to data project explorer?
the only options I can see at data project explorer:
- sql scripts
- stored procedures

  I've read everything I can get my hands on and am still very
confused about the similarities and differences between
db2_mmap_read/write and concurrent i/o.  It seems to me at this point
that they are virtually identical except that db2_mmap_read/write

I want to know about REPLICATION in DB2 UDB in
detail.As i'm going to work on this i would like to
know about it.I want to do it on my PC (if possible) before i can
implement it