Upgrading from 7.23 to 11.10

We are upgrading from 7.23 to 11.10 and have came across an issue that I would appreciate some help with that does not occur on our current system: We have a process that checks a table exists (table X), opens a transaction, creates some indexes on the table and then renames the table from X to Y. We then attempt to create a synonym pointing (Z) to table Y. However when we attempt to prepare the create synonym statement (we are using ESQL/C) it returns error code -206, suggesting that the table does not exist. When we debug the code and get as far as this part of the code we can see that the table exists in the database. Any ideas as to why our create does not work? Thanks in advance

NIGEL FORBES wrote: > We are upgrading from 7.23 to 11.10 and have came across an issue that I would > appreciate some help with that does not occur on our current system: > > We have a process that checks a table exists (table X), opens a transaction, > creates some indexes on the table and then renames the table from X to Y. We > then attempt to create a synonym pointing (Z) to table Y. However when we > attempt to prepare the create synonym statement (we are using ESQL/C) it > returns error code -206, suggesting that the table does not exist. When we > debug the code and get as far as this part of the code we can see that the > table exists in the database. > > Any ideas as to why our create does not work? > At what point is the CREATE SYNONYM statement prepared? Before executing the rename? After but within the same transaction? Art S. Kagel Oninit, LLC. > Thanks in advance > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

It is being prepared after the rename but in the same transaction. I have closed the transaction and opened a new one as well between the rename and statement prpare. It is the prepare that is actually failing rather than executing it

Hi, Are you in a HDR environment ? In this case, I have often found that the create table is not ready if I issue another statement immediatelyafterwards (create index/foreignkey ...). The secondary server has to finish the create table first. Marcus -----Original Message----- From: NIGEL FORBES [mailto:forbes_mail@btinternet.com] Sent: Monday, December 17, 2007 7:41 PM To: ids@iiug.org Subject: Re: Upgrading from 7.23 to 11.10 [10771] It is being prepared after the rename but in the same transaction. I have closed the transaction and opened a new one as well between the rename and statement prpare. It is the prepare that is actually failing rather than executing it ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.

In version 11, if you enable the onconfig parameter LOG_INDEX_BUILDS 1 # logically log content of indexes then the table and its indexes will be available immediate after the statements complete. John = "Marcus Haarmann" = <marcus.haarmann@ = midoco.de> = To Sent by: ids@iiug.org = ids-bounces@iiug. = cc org = Subj= ect RE: Re: Upgrading from 7.23 to = 12/18/2007 12:32 11.10 [10780] = AM = = = Please respond to = ids@iiug.org = = = Hi, Are you in a HDR environment ? In this case, I have often found that th= e create table is not ready if I issue another statement immediatelyafterwards (create index/foreignkey ...). The secondary server has to finish the create table first. Marcus -----Original Message----- From: NIGEL FORBES [mailto:forbes_mail@btinternet.com] Sent: Monday, December 17, 2007 7:41 PM To: ids@iiug.org Subject: Re: Upgrading from 7.23 to 11.10 [10771] It is being prepared after the rename but in the same transaction. I have closed the transaction and opened a new one as well between the rename and statement prpare. It is the prepare that is actually failing= rather than executing it ***********************************************************************= * ******* Forum Note: Use "Reply" to post a response in the discussion forum. ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =