Results 1 to 6 of 6

Thread: Database Load

  1. #1
    Join Date
    May 2008
    Posts
    35

    Unanswered: Database Load

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

  2. #2
    Join Date
    Mar 2008
    Posts
    96
    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."

  3. #3
    Join Date
    May 2008
    Posts
    35
    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.

  4. #4
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    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

  5. #5
    Join Date
    May 2008
    Posts
    35
    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.

  6. #6
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    "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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •