Skip to Content
0
Former Member
May 29, 2013 at 02:42 PM

Load tran takes too long...

191 Views

Hi guys.

I have taken a full dump of a ~3TB database on an ASE 12.5.4, loaded the dump into a new database with the "for load" option on an ASE 15.7. I havn't online'ed the database on the 15.7 as I want to be able to load in tran-dumps from the 12.5.4. Here's the issue. When I issue a "load tran testapay2 from "/usr/local/sybase/dump/tran/deltapay.log.20130523_081501"", the ASE quickly responds with "LOAD is complete (database testapay2).", but afterwards ASE waits for about 40 minutes before it continues with "Started estimating recovery log boundaries..." etc. There's only 15 minutes of transactions in the tran-dump and the file is 41MB. I would expect this to be done in 5 minutes or so. Have any of you experienced this?

This is what it looks like:

1> load tran testapay2 from "/usr/local/sybase/dump/tran/deltapay.log.20130523_081501"

2> go

Backup Server session id is: 46. Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server.

Backup Server: 6.28.1.1: Dumpfile name 'eltapay1314307405' section number 1 mounted on disk file '/usr/local/sybase/dump/tran/deltapay.log.20130523_081501'

Backup Server: 4.58.1.1: Database testapay2: 109184 kilobytes LOADED.

Backup Server: 3.42.1.1: LOAD is complete (database testapay2).

-- ~40 minutes before the next line gets printed to the screen

Started estimating recovery log boundaries for database 'testapay2'.

Database 'testapay2', checkpoint=(2040861, 5), first=(2040861, 4), last=(21551659, 10).

Completed estimating recovery log boundaries for database 'testapay2'.

Started ANALYSIS pass for database 'testapay2'.

Completed ANALYSIS pass for database 'testapay2'.

Started full REDO pass for database 'testapay2'. The total number of log records to process is 844028.

Redo pass for database 'testapay2': 42201 records done (4%); 801827 records left.

Redo pass for database 'testapay2': 84402 records done (9%); 759626 records left.

Redo pass for database 'testapay2': 126603 records done (14%); 717425 records left.

Redo pass for database 'testapay2': 168804 records done (19%); 675224 records left.

Redo pass for database 'testapay2': 211005 records done (24%); 633023 records left.

Redo pass for database 'testapay2': 253206 records done (29%); 590822 records left.

Redo pass for database 'testapay2': 295407 records done (34%); 548621 records left.

Redo pass for database 'testapay2': 337608 records done (39%); 506420 records left.

Redo pass for database 'testapay2': 379809 records done (44%); 464219 records left.

Redo pass for database 'testapay2': 422010 records done (49%); 422018 records left.

Redo pass for database 'testapay2': 464211 records done (54%); 379817 records left.

Redo pass for database 'testapay2': 506412 records done (59%); 337616 records left.

Redo pass for database 'testapay2': 548613 records done (64%); 295415 records left.

Redo pass for database 'testapay2': 590814 records done (69%); 253214 records left.

Redo pass for database 'testapay2': 633015 records done (74%); 211013 records left.

Redo pass for database 'testapay2': 675216 records done (79%); 168812 records left.

Redo pass for database 'testapay2': 717417 records done (84%); 126611 records left.

Redo pass for database 'testapay2': 759618 records done (89%); 84410 records left.

Redo pass for database 'testapay2': 801819 records done (94%); 42209 records left.

Redo pass for database 'testapay2': 844020 records done (99%); 8 records left.

Redo pass of recovery has processed 10857 committed and 0 aborted transactions.

Completed REDO pass for database 'testapay2'.

Use the ONLINE DATABASE command to bring this database online; ASE will not bring it online automatically.

Execution Time (ms.): 22

Clock Time (ms.): 2743390