Technology
Stefan Damian, , , , , Leave a Comment on Manually running ProactiveNet Sybase DB Rebuild
, , , , ,

Manually running ProactiveNet Sybase DB Rebuild

This is an workaround that could be used when standard rebuild procedure fails because of “memory exhausted”: pw database rebuild fails with error Dynamic Memory Exhausted

Manually running the steps and using a larger cache size resolved the issue

1) dbunload -c "LINKS=tcpip;eng=storm_<hostname>;uid=dba;pwd=pronet" -r "D:\ProactiveNet\pw\dbrebuild\reload.sql" -u "D:\ProactiveNet\pw\dbrebuild\unload"
2) dbinit -p 4096 -z UTF8 -j "D:\ProactiveNet\pw\dbrebuild\pronto.db"
3) dbeng9 -qi -d -ch 2000M "D:\ProactiveNet\pw\dbrebuild\pronto.db"
4) dbisqlc -c "LINKS=tcpip;eng=pronto;uid=dba;pwd=sql" -q 
    "D:\ProactiveNet\pw\dbrebuild\reload.sql"

If it still fails try a larger -ch number

Leave a Reply