[dinjo_jo]

Hi All,
How do i ensure after the database load in sybase have been completed successfully.

[ishu.cs]

fire the load database command through a OS file as
1. Create a file in OS using vi editor say loaddb.sh
in file write
isql -U<user name> -P<password> -S<server name> -o<full path for log file> <<eof
use master
go
load database <database name> from "<file name>" stripe on "<file name2>" ...
go
eof


2. check the log file for message

"Completed REDO pass for database <database>.
Use the ONLINE DATABASE command to bring this database online; SQL Server will not bring it online automatically."

[dinjo_jo]

I get something like this in log.

All dumped pages have been loaded. SQL Server is now clearing pages above page
1536000, which were not present in the database just loaded.
SQL Server has finished clearing database pages.
Redo pass: 6000 records done (41%); 8621 records left.
Redo pass: 12000 records done (82%); 2621 records left.
Redo pass of recovery has processed 3479 committed and 0 aborted transactions.

[pdreyer]

Next you should see
Completed REDO pass for database
Use the ONLINE DATABASE command to bring this database online

And after you issue online database <your_database> you should see
Database <your_database> is now online

[dinjo_jo]

This is what i get :-

Backup Server: 4.58.1.1: Database kplus: 3079414 kilobytes LOADed.
Backup Server: 3.42.1.1: LOAD is complete (database kplus).
All dumped pages have been loaded. SQL Server is now clearing pages above page
1536000, which were not present in the database just loaded.
SQL Server has finished clearing database pages.
Redo pass: 6000 records done (9%); 55064 records left.
Redo pass: 12000 records done (19%); 49064 records left.
Redo pass: 18000 records done (29%); 43064 records left.
Redo pass: 24000 records done (39%); 37064 records left.
Redo pass: 30000 records done (49%); 31064 records left.
Redo pass: 36000 records done (58%); 25064 records left.
Redo pass: 42000 records done (68%); 19064 records left.
Redo pass: 48000 records done (78%); 13064 records left.
Redo pass: 54000 records done (88%); 7064 records left.
Redo pass: 60000 records done (98%); 1064 records left.
Redo pass of recovery has processed 15089 committed and 0 aborted transactions.
Use the ONLINE DATABASE command to bring this database online; SQL Server will
not bring it online automatically.


Is there a location in a system table which identifies whether database has been loaded successfully or not.

[pdreyer]

"LOAD is complete (database kplus)."
Indicate that the load completed
And "Redo pass of recovery has processed ..."
Indicate that the redo is completed
To make the database available you need to do as the message said
"Use the ONLINE DATABASE command to bring this database online"
i.e.
online database kplus
go