Sybase IQ Point in time recovery backup

[Former Member]

Hi ,

I was trying to Setup Sybase IQ  Point in time recovery log backup as per the Admin guide in SP08  .

As per  the guide , We should enable it like as below:

1. SET OPTION PUBLIC.IQ_POINT_IN_TIME_RECOVERY_LOGGING = 'ON'

2. ALTER DBSPACE IQ_SYSTEM_LOG RENAME '/My Directory/<prefix> '

3. BACKUP DATABASE FULL to '/demo/dataBackup/FULL1'

After 2nd step , DB is getting crashed with below error :

-----------------

Error! The connection to the database was closed by the server.

  Communication error

  SQLCODE=-85, ODBC 3 State="08S01"

  Line 1, column 1

  ALTER DBSPACE IQ_SYSTEM_LOG RENAME My Directory/<prefix>

--------------------

I tried for creation  IQ_SYSTEM_LOG but says the

"CREATE DBSPACE IQ_SYSTEM_LOG AS ' My Directory/<prefix>"

Could not execute statement.

  Item 'IQ_SYSTEM_LOG' already exists

  SQLCODE=-110, ODBC 3 State="42S01"

  Line 1, column 1

  CREATE DBSPACE IQ_SYSTEM_LOG AS '/ My Directory/<prefix>'

----------------------------------------

I tried the following SQL to check current  DBSPACES

select * from SYSDBSPACE but  IQ_SYSTEM_LOG  is not listed

-----------------------

Can someone please help me here for the same and share best practices, So that i can enable automatic backups .

Thanks,

Razal

[tayeb_hadjou]

Hi Mohammed,

Are there any other errors , stacktrace logged in iqmsg?

Is the physical file created ?

Which Platform/OS IQ is running on?

Regards,

Tayeb.

[Former Member]

Hi Team,

We are running on Suse Linux

I created directory and run given prefix

Yes , Stacktrace is created , How can i provide you those details ?

Thanks,

Razal

[tayeb_hadjou]

This requires stacktrace analysis. I suggest open new SAP Incident in BC-SYB_IQ component and attach the stacktrace.

Regards,

Tayeb.

[Former Member]

Please let us know if this was a bug and if so, # and approximately when it will be fixed.

[Former Member]

Hi Jason,

This issue is fixed , It is working awesome now

Thanks for you attentions .

Best,

Razal

[SybDBA]

Hi Mohammed,

Can you please, let the community know the solution of this issue ?

If you will do so it will be helpful for many more, like you.

Beside this please mark this thread as 'ANSWERED', if you got the solution from other sources.

Thanks,

Pankaj