Help with Oracle -- DB2 gateway!

From: Sreeni Karpurapu <karpurapus_at_detroitedison.com>
Date: 1997/10/02
Message-ID: <01bccf3f$cecd94c0$185909a2@karpurapus.deco.com>#1/1

Hello everybody:

We are having problems with Oracle DB2 gateway! Our Oracle Forms application is interfacing with a DB2 database through a Oracle-DB2 gateway. We are having lot of locking problems(table level locks). Even if we do a select though SQL*Plus locks get established and they don't go untill we do a COMMIT or ROLLBACK. Some *THREADS* are still persistant on the DB2 machine and they have to be removed manually.

Further we have some not null columns in some of the DB2 tables. And when we try to insert data with spaces ' ' into those columns, it would not accept spaces! It has to be some other character!

This really sounds wierd. Are there any parameters to be fixed in the Oracle-DB2 gateway?

Could you please give me your opinion/ suggestions on this Oracle-DB2 gateway behaviour.

Thans-A-Ton

Sreeni

-- 


========================================

Sreeni Karpurapu 
Oracle, SAP DBA
Miracle Software Systems
Southfield, MI 48034


========================================

Received on Thu Oct 02 1997 - 00:00:00 CDT