Hi - I would be grateful for any knowledge regarding the following.
Whilst QAing Stored Procedures developed by colleagues, I noticed the
following 'superflous' parameter specifications:-
1) "Modifies SQL Data" - where the Stored Procedure is Select only.

ENVIRONMENT:
________________________________________________________
"Server 1" = DB2 UDB ESE 7.1 FP7 on AIX 5.1
"Server 2" = DB2 UDB ESE 8.1 FP2 on AIX 5.1

I have a table that contains 15lakh records.....
I want delete that table....and insert fresh set of record.
when I run the command ...db2 "delete from schema.tabname"
it hangs .......the system it seems hangs...

i need to restore an old database. The db was backed up using a DLT drive,
using 2 volumes. The content for the tapes was copied to file onto Solaris
machine using rsh and dd (for backup purposes). Now, the drive is defective
and can't read the tapes anymore.

I need the below sybase code  to be migrated in UDB :
select distinct
  c.partnumber                as I_PART,
case

First, I´m sorry for my English...
Always I quiesce a database, the instance crashes. This occurs only with
one database, I can quiesce other databases in the same instance and
nothing occur. These database isn´t in use, and hasn´t any federated

Please bear with me, as I am a newbie in the world of databases and DB2.
We are trying to migrate an application that binds to a DB2 database
(Workgroup Edition, V6.1) from a server running Windows NT 4.0, to a new
server running Windows 2000. Since DB2 V6.1 is no longer supported ...

Is there any way of restricting access to a database by application &
account?  For example, I only want the application APP1 to access the
database using the USER1 account. I've tried to use the DB2 Governor to
do this, but it seems it always allows the the first query to be

Does somebody know the efficent way to connect DB2/400? Through iSeries
Access ODBC/OLEDB driver or DB2 Connect? Which will more fast and
efficent?
In addition, does DB2 Connect use APPC over TCP/IP protocol? Or SNA

The following CarsElement XML data type is passed in CTE. Can XML data
type be passed as out parameter for SQL stored procedure or returned in
SQL UDF.
WITH CarsDef(CarsElement) as

I have 8.1.5 on Windows 2003, when I do from CLP with auto commit off:
db2 update table set column=something
and then
db2 terminate

DB2 ESE v8.1 Fixpak 10
For a single partition database, with INTRA_PARALLEL=NO
does FCM_NUM_BUFFERS have any effect on performance?
After reading DB2 Magazine Tuning Up for OLTP and Data Warehousing, I

We will change few columns data type from varchar(40) to varchar(60) in
our 8.1 replica environment. What's the procedure?
Thanks a lot!

I have table A with 2 columns: PK [integer] and Txt [varchar(128)],
size - 1000 rows. Also, I have table B with 100000 rows and 100 integer
columns, each one is a foreign key to A's PK. I need to create a view
in which every cell of B is replaced by the Txt from A according to the

On Unix, how can we calculate the shared memory currently being used by
the database instance.
Reason for this is that we have a limit to the size of shared memory
that can be configured for use by the database. eg., Linux 1.74 GB per