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