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
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.