I need to create a fake DB2 backup.
Every night the database backup runs, but sometimes during the day, i create
a scenario that puts me in backup pending mode.
Or in this case, i am on a test machine that is not officially production yet.

What size is set for the bufferpool when "alter bufferpool....size -1
" is issued.
Deogirikar.

Hi, DBAs and application developers out there,
which IDE is the best for DB2? I've been used to TOAD on Oracle, but
the new project uses DB2 and I hope to hear some good suggestions.
I've tried Toad for DB2 free, but it is buggy and hangs and disappears

I am unable to receive (and examine) the SQLSTATE returns in
VisualBasic 6 ADO.
Anyone know how to do this?
SS

I have done db2 installation and configuration of database on a
server. And I am getting below error in db2diag.log Does anyone know
the reason of getting this error. In my db cfg I am using archival
logging (userexit on).

Does anyone knows how to recover the test file db2diag.log. By mistake
I have delete the contents of db2diag.log, wondering if I could
restore the contents of my db2diag.log.

  I have a newbie question regarding stored procedures and locking.
I'm trying to use a stored
  procedure to perform a 'select for update' and return a cursor.
Below is a stripped down version

I wanted to know on which parameters does database capacity depend on?
Is it only dependent on the tablespaces size that i have allocated?
I am getting the following.
C:\Program Files\IBM\SQLLIB\BIN>db2 call get_dbsize_info(?, ?, ?, 0)

Now I have some other question.
Our application installs DB2 Express Edition C V9.0  and then restores
the master database.
But there are other lower versions of DB2 in the client systems

I am getting the error "SQL2216N  SQL error "-968" occurred while
reorganizing a database table or its indexes."
What could be the reason for this?
The documentation says "The File System is full" for this error.

SELECT ... ORDER BY ... FETCH FIRST 100 ROWS ONLY
has awful performance in DB2 8.2.3 at all optimization levels and all
possible
SORTHEAP sizes etc since ORDER BY does an external (spilled) sort

Hi, All
In the first place sorry for mu english.
I'm trying to integrate DB2 9.1.3 (with WebSphere Federation Server
Relational Wrappers installed) and PostgreSQL 7.4  on SLES9 box

since morning i am facing a problem on all db's on a server
if i recreate a procedure and give grants to users ...it justs stop
responding
my last grant is now running for 1 hrs

I am unable to reorganise the tables and get an error
"SQL2216N  SQL error "-968" occurred while reorganizing a database
table or its indexes."
Further, i find that all these tables belong to a tablespace and i

Need some help understanding how to tie together a trigger and a
procedure together. I want to do a certain procedure if an insert
occurs on TABLE1:
TABLE1 contains COL1, COL2, COL3, COL4