OI 10.20/6.4 Star query timeout problem

OI 10.20/6.4 Star query timeout problem

Post by Ken Walte » Tue, 17 Nov 1998 04:00:00



I have a 2.0 Star database under HP-UX 10.20. I am executing a query
in the Star database that selects * from a 6.4 installation and
inserts the result  into a table in a 2.0 installation. The problem is
that it takes Ingres so long to build the table over in the 2.0
database that the 6.4 installation times out the query before Two
Phase Commit can take place.
Is there any way to adjust how long the 6.4 installation will wait for
the commit signal from the Star query? I did not see anything in CBF
or the Star docs. I would rather not divide my 6.4 table up into
smaller pieces. Yes, the table I am inserting into is heap.
Thanks
--
Ken Walters

Database Administration Manager
Public Braodcasting Service

 
 
 

1. Upgrading from 6.4 to OI 1.2 and 6.4 to OI 1.1/04

Hello out there !

Have anybody made a recipy for converting a 6.4 DB to a 1.2 DB on a Unix
server.
If someone have made a list from A-Z during making this operation, I would
like to have a copy of this list.....

I would also like a similar recipy if anyone have converted ABF
applications from 6.4 to OI 1.1/04 on VAX/VMS .....

Regards ....

Inge O. Seth

2. Open Server message Q problem

3. 6.4/06 on HP-UX 10.20

4. 27887-OR-Greater Eugene Area-HP-UX-ORACLE-Cellworks-Sr. Prog. Analyst

5. HP-UX 10.20 and Ingres 6.4 Performance

6. ATLANTA Oracle DBA

7. Varchar problem in reloading from unix 6.4 to NT OI 2.0

8. Errors

9. OI 2.0 HP-UX 10.20 Servers vs CPUs

10. OI 2.0 HP-UX 10.20 and vxfs file systems

11. 6.4 compatibility with OI

12. Use Upgradefe to upgrade a database from version CA-Ingres 6.4/04 and OI 1.2/00