SAP Knowledge Base Article - Preview

2195105 - Alter database raises Error 5030 "The database db_name is in the middle of a load sequence..." - SAP ASE

Symptom

  • The 'alter database' command raises Error 5030:

1> alter database db_name on dev=39000
2> go
Extending database by 19968000 pages (39000.0 megabytes) on disk dev
Processed 7800 allocation unit(s) out of 78000 units (allocation page 546258688). 10% completed.
Processed 15600 allocation unit(s) out of 78000 units (allocation page 548255488). 20% completed.
Processed 23400 allocation unit(s) out of 78000 units (allocation page 550252288). 30% completed.
Processed 31200 allocation unit(s) out of 78000 units (allocation page 552249088). 40% completed.
Processed 39000 allocation unit(s) out of 78000 units (allocation page 554245888). 50% completed.
Processed 46800 allocation unit(s) out of 78000 units (allocation page 556242688). 60% completed.
Processed 54600 allocation unit(s) out of 78000 units (allocation page 558239488). 70% completed.
Processed 62400 allocation unit(s) out of 78000 units (allocation page 560236288). 80% completed.
Processed 70200 allocation unit(s) out of 78000 units (allocation page 562233088). 90% completed.
Processed 78000 allocation unit(s) out of 78000 units (allocation page 564229888). 100% completed.
Msg 5030, Level 16, State 1:
Server 'SVR_NAME', Line 1:
The database db_name is in the middle of a load sequence. Altering it will not let you load other transaction dumps in the dump-set. If you still prefer to do it please use OVERRIDE option.

  • In this scenario, the process is 'alter database' which is not in load sequence.
  • The orignal database size was 1063012.0 MB.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE)  15.5
  • SAP Adaptive Server Enterprise (ASE)  15.7
  • SAP Adaptive Server Enterprise (ASE)  16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; Sybase Adaptive Server Enterprise 15.5

Keywords

CR687834, CR#687834, 687834,  63GB, GAM, sysgams, extent, 444698, CR444698, CR#444698 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.