This is a discussion on Question about multi-volume prostrct add V8.3 within the pgsql Databases forums, part of the PostgreSQL category; --> Hello, running Progress V8.3C11 under SCO Unix OSR5.0x, multi-volume databases. I defined a database_name.st file with 5 fixed volume ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hello, running Progress V8.3C11 under SCO Unix OSR5.0x, multi-volume databases. I defined a database_name.st file with 5 fixed volume (500000 blks) and 1 variable volume. when I'll see the variable volume begins to grow, I'd like to add some volumes. Qu: do I'll have to fix the size of the 6th volume to its actual size, or could I fix it to 500000 blks ? and add a new variable volume in all cases. Thank's. F. STOCK -- **************** Enlever ".remove-me" dans l'adresse. Remove ".remove-me" from e-mail. **************** |
| |||
| =?ISO-8859-1?Q?Fr=E9d=E9ric_STOCK?= Wrote: > Hello > > running Progress V8.3C11 under SCO Unix OSR5.0x, multi-volum > databases > I defined a database_name.st file with 5 fixed volume (500000 blks > an > 1 variable volume > when I'll see the variable volume begins to grow, I'd like to ad > som > volumes > Qu: do I'll have to fix the size of the 6th volume to its actua > size > or could I fix it to 500000 blks > and add a new variable volume in all cases > > Thank's > F. STOC > > - > *************** > Enlever ".remove-me" dans l'adresse > Remove ".remove-me" from e-mail > **************** When adding an extent, the variable exting will be fixed at its curren size. To get around this, create a new .st file with your desire layout. Backup you database with the probkup utility, delete th existing db and do a prostrct create from the new .st file. Then do prorest -- cecsn ----------------------------------------------------------------------- cecsno's Profile: http://www.progresstalk.com/member.p...nfo&userid=423 View this thread: http://www.progresstalk.com/showthre...?threadid=7196 |
| ||||
| Hello, thank's . F. STOCK cecsno a écrit : >=?ISO-8859-1?Q?Fr=E9d=E9ric_STOCK?= Wrote: > > >>Hello, >> >>running Progress V8.3C11 under SCO Unix OSR5.0x, multi-volume >>databases. >>I defined a database_name.st file with 5 fixed volume (500000 blks) >>and >>1 variable volume. >>when I'll see the variable volume begins to grow, I'd like to add >>some >>volumes. >>Qu: do I'll have to fix the size of the 6th volume to its actual >>size, >>or could I fix it to 500000 blks ? >>and add a new variable volume in all cases. >> >>Thank's. >>F. STOCK >> >>-- >>**************** >>Enlever ".remove-me" dans l'adresse. >>Remove ".remove-me" from e-mail. >>**************** >> >> >When adding an extent, the variable exting will be fixed at its current >size. To get around this, create a new .st file with your desired >layout. Backup you database with the probkup utility, delete the >existing db and do a prostrct create from the new .st file. Then do a >prorest. > > > > -- **************** Enlever ".remove-me" dans l'adresse. Remove ".remove-me" from e-mail. **************** |