How to reset SYSADM password?

[c50a20]

I know the sysadm password can not be reset. But is there any alternative way to dig out the lost SYSADM password?
One of our customer has lost his SYSADM password.
Please help...

 

[ManuelPallas]

Sorry...no way to find it out...the only possibility is to unload the database, with an other user, table by table and load it again in a new database!

 

[c50a20]

Thanks for your valuable information, I am trying that only. But I don't know any user in database having admin priviledges. I tried table by table unload using SYSSQL user, but giving me an error - Error: 04409 UNL CUS Unload of system table not allowed.

 

[ManuelPallas]

thats right...you can only unload the non-system-tables. but you don´t have to unload them because when you create a new database to load the unloaded data, all the systables are exists in a empty sqlbase database! Only the user tables, I mean all the table which are created additional to the database, have to be unloaded!