IQ 15.x and 16.x forced recovery steps

[jmtorres]

Hello,

After booting SAP IQ with the force recovery flag( iqfrec), which are  the steps for fixing the free list ?.

In older versions I've used -iqdrolks and  then sp_iqcheckdb  "allocation database", but as "droplks" is deprecated in 15 and 16, which should be the steps to follow after  booting with iqfrec?

Thank you

regards

Jose

[saroj_bagai · Accepted solution]

once the server is up with the -iqfrec flag    using dbisql:

set temporary option dbcc_log_progress=on

sp_iqcheckdb  'dropleaks database'

if no errors

then issue

checkpoint twice

and restart server normally

[jmtorres]

Saroj/Shashi

Thanks a lot guys

Regards

Jose

[former_member333181]

Hi,

  You should be able to run sp_iqcheckdb 'dropleaks database' command. Always advisable to open an incident with SAP support to make sure you are not doing forced recovery which might cause further problems.

Regards

Shashi