Sybase ASE – Load Database from a Cross-Platform Dump File using sp_post_xpload

If you’re loading a database from another O/S, not only does the dump file need to be created in a quiesced state, but after the load we need to issue the sp_post_xpload command to rebuild any corrupted indexes that maybe present.

Start by loading the database as usual:-

load database <DB Name> from "compress::<Dumpfile_Path_and_Filename>"
go

You’ll notice many cross-platform conversion messages in the output:-

Started cross-platform conversion for database .
Started cross-platform conversion for system objects.
Cross-platform conversion for database : 926 pages completed.
Completed cross-platform conversion for system objects.
Started cross-platform conversion for user objects.
Cross-platform conversion for database : 10072 pages completed.
Cross-platform conversion for database : 20272 pages completed.


Completed cross-platform conversion for log records.
Completed cross-platform conversion for database .

Once the load is completed, issue ONLINE DATABASE command to bring the database online:-

online database <DB Name>

During online database you would notice many informational message mainly about index rebuild but at the last you’ll see following message:-

WARNING: One or more indexes on user tables may have been marked as 'suspect' making these indexes unusable. Use the sp_post_xpload stored procedure to check and rebuild these indexes.
Database '' is now online.

Above warning requests for executing sp_post_xpload procedure to check and rebuild all the indexes that were not rebuild during ONLINE DATABASE command.

use 
go
sp_post_xpload
go


One thought on “Sybase ASE – Load Database from a Cross-Platform Dump File using sp_post_xpload

  1. Pingback: Sybase ASE | Oracle Database Internal Mechanism

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.