Welcome to the dBforums forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions, articles and access our other FREE features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload your own photos and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact support.

If you prefer not to see double-underlined words and corresponding ads, place your cursor
here for ContentLink opt out.

Go Back  dBforums > Database Server Software > Sybase > Database Load

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 06-11-08, 08:39
dinjo_jo dinjo_jo is offline
Registered User
 
Join Date: May 2008
Posts: 6
Database Load

Hi All,
How do i ensure after the database load in sybase have been completed successfully.
Reply With Quote
  #2 (permalink)  
Old 06-11-08, 11:13
ishu.cs ishu.cs is offline
Registered User
 
Join Date: Mar 2008
Posts: 19
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."
Reply With Quote
  #3 (permalink)  
Old 06-12-08, 00:54
dinjo_jo dinjo_jo is offline
Registered User
 
Join Date: May 2008
Posts: 6
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.
Reply With Quote
  #4 (permalink)  
Old 06-12-08, 02:59
pdreyer pdreyer is offline
Registered User
 
Join Date: May 2005
Location: South Africa
Posts: 830
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
Reply With Quote
  #5 (permalink)  
Old 06-12-08, 06:07
dinjo_jo dinjo_jo is offline
Registered User
 
Join Date: May 2008
Posts: 6
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.
Reply With Quote
  #6 (permalink)  
Old 06-12-08, 07:22
pdreyer pdreyer is offline
Registered User
 
Join Date: May 2005
Location: South Africa
Posts: 830
"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
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On