Mike
Moderator
Hi Team,
We are planning to move our OpenEdge 10.2A database files to new storage on the same server.
The database extents are currently located across /datos, /indices, /bimage, and /aimage.
Could you please provide the step-by-step procedure for this activity, including:
- Database and application shutdown steps
- Safe method to move the data, index, BI and AI extents
- Changes required if the mount-point names change
- Database and application startup steps
- Post-migration validation
- Rollback steps
- Expected downtime
Please also let us know what database and server details you need from us to prepare the procedure.
Multi-user session begin.
[2019/06/15@05:45:04.980-0400] P-25810 T-1 I BROKER 0: (4234) Progress OpenEdge Release 10.2A build 1185 on HP-UX sapian B.11.31 U.
[2019/06/15@05:45:04.980-0400] P-25810 T-1 I BROKER 0: (4281) Server started by root on batch.
# proutil -C dbipcs
OpenEdge Release 10.2A as of Fri Oct 2 21:05:05 EDT 2008
PROGRESS SHARED MEMORY STATUS
ID ShMemVer Seg# InUse Database
0 - - - (not PROGRESS)
1 - - - (not PROGRESS)
2 - - - (not PROGRESS)
32771 - - - (not PROGRESS)
4 - - - (not PROGRESS)
5 - - - (not PROGRESS)
6 6412003 0 Yes /data/ladb3/ladb3.db
7 6412003 0 Yes /data/ladb4/ladb4.db
8 6412003 0 Yes /data/lagdb2/lagdb2.db
9 6412003 0 Yes /data/help1/help1.db
10 - - - (not PROGRESS)
11 - - - (not PROGRESS)
/data/ladb3/ladb3.db :- 35 GB size
/data/ladb4/ladb4.db 20gb
/data/lagdb2/lagd2.db 88157 MB
/data/help1/help1.db 267 mb
Enter your selection: q
# df
/aimage (/dev/vg01/lvol4 ): 56590590 blocks 7545411 i-nodes
/apps (/dev/vg02/lvol4 ): 9452446 blocks 1260155 i-nodes
/backups (/dev/vg01/lvol3 ): 87455358 blocks 11660679 i-nodes
/bimage (/dev/vg02/lvol5 ): 56029142 blocks 7470549 i-nodes
/ctry (/dev/vg02/lvol3 ): 6325180 blocks 817410 i-nodes
/datos (/dev/vg00/lvol9 ): 85939802 blocks 11458608 i-nodes
/home (/dev/vg00/lvol5 ): 154336 blocks 8117 i-nodes
/indices (/dev/vg01/lvol2 ): 91926878 blocks 12256914 i-nodes
/olap (/dev/vg02/lvol2 ): 28484742 blocks 3797259 i-nodes
/opt (/dev/vg00/lvol6 ): 3434832 blocks 54069 i-nodes
/pruebas (/dev/vg02/lvol1 ): 97539400 blocks 13005212 i-nodes
/tmp (/dev/vg00/lvol4 ): 448304 blocks 7038 i-nodes
/usr (/dev/vg00/lvol7 ): 7437536 blocks 117115 i-nodes
/var (/dev/vg00/lvol8 ): 4768848 blocks 74864 i-nodes
/stand (/dev/vg00/lvol1 ): 2877248 blocks 45300 i-nodes
/ (/dev/vg00/lvol3 ): 2005936 blocks 31587 i-node
# proutil /data/lagdb3/lagdb3 -C describe
OpenEdge Release 10.2A as of Fri Oct 31 21:05:05 EDT 2008
OpenEdge Database Description
Database Name : /data/lagdb3/lagdb3
Version : 150.0
Block Size : 8192
Largest Cluster : 64
Create Date : Fri Jun 19 23:36:13 2015
Last Open Date : Sat Nov 15 09:31:02 2025
Prior Open Date : Sat Nov 15 09:31:02 2025
Schema Change Date : Thu Jan 4 15:20:39 2018
Before Imaging information
Block Size : 8192
Cluster Size (16K Units) : 32
Last Open Date : Sat Nov 15 09:31:03 2025
Backup Information
Last Full Backup Date : Sat Nov 15 03:55:00 2025
Last Incremental Backup : *** Not yet performed ***
Database Features
ID Feature Active Details
---- --------------------------------- ------ -------
5 Large Files Yes
9 64 Bit DBKEYS Yes
10 Large Keys Yes
11 64 Bit Sequences Yes
# cat help10.st
#
b /bimage/lahelp/ f 100096
b /bimage/lahelp/
#
d "Schema Area":6,64;1 .
#
d "Common_Area":7,64;64 . f 200064
d "Common_Area":7,64;64 .
#
d "indices":8,64;64 /indices/lahelp/ f 100096
d "indices":8,64;64 /indices/lahelp/
#
a /aimage/lahelp/ f 100096
#
a /aimage/lahelp/ f 100096
#
a /aimage/lahelp/
# cat ladb1.st
#
b /bimage/ladb1 f 100000
b /bimage/ladb1 f 100000
b /bimage/ladb1
#
d "Schema Area":6,64;1 .
#
d "Lower_Area":7,128;64 . f 1536000
d "Lower_Area":7,128;64 . f 1536000
d "Lower_Area":7,128;64 .
#
d "Low_Area":8,64;64 . f 3048000
d "Low_Area":8,64;64 .
#
d "Medium_fcs_sum_Area":9,64;64 . f 2000000
d "Medium_fcs_sum_Area":9,64;64 .
#
d "Medium_idh_hist_Area":10,32;64 . f 2560000
d "Medium_idh_hist_Area":10,32;64 .
#
d "Medium_trgl_det_Area":11,128;64 . f 5000000
d "Medium_trgl_det_Area":11,128;64 .
#
d "Heighter_tr_hist_Area":12,64;512 . f 5000000
d "Heighter_tr_hist_Area":12,64;512 .
#
d "Common_Area":13,128;64 . f 3536000
d "Common_Area":13,128;64 .
#
d "Index_area":14,1;8 /indices/ladb1 f 4000000
d "Index_area":14,1;8 /indices/ladb1
#
a /aimage/ladb1 f 200064
a /aimage/ladb1 f 200064
a /aimage/ladb1 f 200064
a /aimage/ladb1
# uname -a
HP-UX sapian B.11.31 U ia64 4209233176 unlimited-user license
#
We are planning to move our OpenEdge 10.2A database files to new storage on the same server.
The database extents are currently located across /datos, /indices, /bimage, and /aimage.
Could you please provide the step-by-step procedure for this activity, including:
- Database and application shutdown steps
- Safe method to move the data, index, BI and AI extents
- Changes required if the mount-point names change
- Database and application startup steps
- Post-migration validation
- Rollback steps
- Expected downtime
Please also let us know what database and server details you need from us to prepare the procedure.
Multi-user session begin.
[2019/06/15@05:45:04.980-0400] P-25810 T-1 I BROKER 0: (4234) Progress OpenEdge Release 10.2A build 1185 on HP-UX sapian B.11.31 U.
[2019/06/15@05:45:04.980-0400] P-25810 T-1 I BROKER 0: (4281) Server started by root on batch.
# proutil -C dbipcs
OpenEdge Release 10.2A as of Fri Oct 2 21:05:05 EDT 2008
PROGRESS SHARED MEMORY STATUS
ID ShMemVer Seg# InUse Database
0 - - - (not PROGRESS)
1 - - - (not PROGRESS)
2 - - - (not PROGRESS)
32771 - - - (not PROGRESS)
4 - - - (not PROGRESS)
5 - - - (not PROGRESS)
6 6412003 0 Yes /data/ladb3/ladb3.db
7 6412003 0 Yes /data/ladb4/ladb4.db
8 6412003 0 Yes /data/lagdb2/lagdb2.db
9 6412003 0 Yes /data/help1/help1.db
10 - - - (not PROGRESS)
11 - - - (not PROGRESS)
/data/ladb3/ladb3.db :- 35 GB size
/data/ladb4/ladb4.db 20gb
/data/lagdb2/lagd2.db 88157 MB
/data/help1/help1.db 267 mb
Enter your selection: q
# df
/aimage (/dev/vg01/lvol4 ): 56590590 blocks 7545411 i-nodes
/apps (/dev/vg02/lvol4 ): 9452446 blocks 1260155 i-nodes
/backups (/dev/vg01/lvol3 ): 87455358 blocks 11660679 i-nodes
/bimage (/dev/vg02/lvol5 ): 56029142 blocks 7470549 i-nodes
/ctry (/dev/vg02/lvol3 ): 6325180 blocks 817410 i-nodes
/datos (/dev/vg00/lvol9 ): 85939802 blocks 11458608 i-nodes
/home (/dev/vg00/lvol5 ): 154336 blocks 8117 i-nodes
/indices (/dev/vg01/lvol2 ): 91926878 blocks 12256914 i-nodes
/olap (/dev/vg02/lvol2 ): 28484742 blocks 3797259 i-nodes
/opt (/dev/vg00/lvol6 ): 3434832 blocks 54069 i-nodes
/pruebas (/dev/vg02/lvol1 ): 97539400 blocks 13005212 i-nodes
/tmp (/dev/vg00/lvol4 ): 448304 blocks 7038 i-nodes
/usr (/dev/vg00/lvol7 ): 7437536 blocks 117115 i-nodes
/var (/dev/vg00/lvol8 ): 4768848 blocks 74864 i-nodes
/stand (/dev/vg00/lvol1 ): 2877248 blocks 45300 i-nodes
/ (/dev/vg00/lvol3 ): 2005936 blocks 31587 i-node
# proutil /data/lagdb3/lagdb3 -C describe
OpenEdge Release 10.2A as of Fri Oct 31 21:05:05 EDT 2008
OpenEdge Database Description
Database Name : /data/lagdb3/lagdb3
Version : 150.0
Block Size : 8192
Largest Cluster : 64
Create Date : Fri Jun 19 23:36:13 2015
Last Open Date : Sat Nov 15 09:31:02 2025
Prior Open Date : Sat Nov 15 09:31:02 2025
Schema Change Date : Thu Jan 4 15:20:39 2018
Before Imaging information
Block Size : 8192
Cluster Size (16K Units) : 32
Last Open Date : Sat Nov 15 09:31:03 2025
Backup Information
Last Full Backup Date : Sat Nov 15 03:55:00 2025
Last Incremental Backup : *** Not yet performed ***
Database Features
ID Feature Active Details
---- --------------------------------- ------ -------
5 Large Files Yes
9 64 Bit DBKEYS Yes
10 Large Keys Yes
11 64 Bit Sequences Yes
# cat help10.st
#
b /bimage/lahelp/ f 100096
b /bimage/lahelp/
#
d "Schema Area":6,64;1 .
#
d "Common_Area":7,64;64 . f 200064
d "Common_Area":7,64;64 .
#
d "indices":8,64;64 /indices/lahelp/ f 100096
d "indices":8,64;64 /indices/lahelp/
#
a /aimage/lahelp/ f 100096
#
a /aimage/lahelp/ f 100096
#
a /aimage/lahelp/
# cat ladb1.st
#
b /bimage/ladb1 f 100000
b /bimage/ladb1 f 100000
b /bimage/ladb1
#
d "Schema Area":6,64;1 .
#
d "Lower_Area":7,128;64 . f 1536000
d "Lower_Area":7,128;64 . f 1536000
d "Lower_Area":7,128;64 .
#
d "Low_Area":8,64;64 . f 3048000
d "Low_Area":8,64;64 .
#
d "Medium_fcs_sum_Area":9,64;64 . f 2000000
d "Medium_fcs_sum_Area":9,64;64 .
#
d "Medium_idh_hist_Area":10,32;64 . f 2560000
d "Medium_idh_hist_Area":10,32;64 .
#
d "Medium_trgl_det_Area":11,128;64 . f 5000000
d "Medium_trgl_det_Area":11,128;64 .
#
d "Heighter_tr_hist_Area":12,64;512 . f 5000000
d "Heighter_tr_hist_Area":12,64;512 .
#
d "Common_Area":13,128;64 . f 3536000
d "Common_Area":13,128;64 .
#
d "Index_area":14,1;8 /indices/ladb1 f 4000000
d "Index_area":14,1;8 /indices/ladb1
#
a /aimage/ladb1 f 200064
a /aimage/ladb1 f 200064
a /aimage/ladb1 f 200064
a /aimage/ladb1
# uname -a
HP-UX sapian B.11.31 U ia64 4209233176 unlimited-user license
#
