You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
I/O Error
- Thread starter Elvis
- Start date
You did not say what you were doing, or system and version.
This is out of disk space or a file exceeding 2Gig limit, a .bi or .srt file.
This is out of disk space or a file exceeding 2Gig limit, a .bi or .srt file.
Elvis said:Hi,
I am getting the next error:
I/O Eroor 0 in Writeit, ret 1023, file 7, addr 0
System Error: Error de busqueda 2,, fich. 7, dir -2147420160. (163)
I think it might be something to do with the hard disk, can anyone help me with this?
Thank in advance!
Elvis De Gracia
Ok.
I have Progress Version 6.3 and AIX version 4.3.
The database status when I get the error show the next:
-rw-rw-rw- 1 ggg ggg 65536 Apr 06 09:51 base1.bi
-rw-rw-rw- 1 ggg ggg 2147483647 Apr 06 09:51 base1.db
-rw-rw-rw- 1 ggg ggg 1755 Apr 06 10:30 base1.lg
I need Help.............
I have Progress Version 6.3 and AIX version 4.3.
The database status when I get the error show the next:
-rw-rw-rw- 1 ggg ggg 65536 Apr 06 09:51 base1.bi
-rw-rw-rw- 1 ggg ggg 2147483647 Apr 06 09:51 base1.db
-rw-rw-rw- 1 ggg ggg 1755 Apr 06 10:30 base1.lg
I need Help.............
You have a single volume database (base1.db) it has reach 2 gig, it needs to be converted to a multi-volume database.
Elvis said:Ok.
I have Progress Version 6.3 and AIX version 4.3.
The database status when I get the error show the next:
-rw-rw-rw- 1 ggg ggg 65536 Apr 06 09:51 base1.bi
-rw-rw-rw- 1 ggg ggg 2147483647 Apr 06 09:51 base1.db
-rw-rw-rw- 1 ggg ggg 1755 Apr 06 10:30 base1.lg
I need Help.............
lets see if i can help you.
lets say ur path is /usr/databases/live/base1.db.
1. First of all make a new directory
"mkdir dbbakup" in any other directory or in /usr/databases/live/
2. MOVE your current single DB in /usr/databases/live/dbbakup
directory.
3. now create a dbname.st file i.e. base1.st & contents of that file shud be
*
*
d /usr/databases/live/base1.d1 f 500000
d /usr/databases/live/base1.d2 f 500000
d /usr/databases/live/base1.d3 f 500000
d /usr/databases/live/base1.d4 f 500000
d /usr/databases/live/base1.d5 f 500000
d /usr/databases/live/base1.d6 f 500000
d /usr/databases/live/base1.d7 f 500000
d /usr/databases/live/base1.d8 f 500000
d /usr/databases/live/base1.d9
b /usr/databases/live/base1.b1
Now you can make few decision on ur own based on ur disk space. This configuration will hog almost 4GB + future growth of ur space. Similarly how many extents u need to define thats also entirely ur decision. Location of bi file is also upon you.
Back to the tutorial. Save this base1.st file in the same directory /usr/databases/live/.
4. run the command "prostrct create base1" this command will create a MV db structure which is void, u will see the status of this command as extents being created.
5. now Last step:- "procopy /usr/databases/live/dbbakup/base1 /usr/databases/live/base1"
this will copy single volume backedup base1 DB in to newly created MV base1 DB.
This utility will give u status in %.
I suggest you also read SAG from progress to get more understanding of how these things are done. Though my instructions will help you convert ur Single DB to MV DB.
lets say ur path is /usr/databases/live/base1.db.
1. First of all make a new directory
"mkdir dbbakup" in any other directory or in /usr/databases/live/
2. MOVE your current single DB in /usr/databases/live/dbbakup
directory.
3. now create a dbname.st file i.e. base1.st & contents of that file shud be
*
*
d /usr/databases/live/base1.d1 f 500000
d /usr/databases/live/base1.d2 f 500000
d /usr/databases/live/base1.d3 f 500000
d /usr/databases/live/base1.d4 f 500000
d /usr/databases/live/base1.d5 f 500000
d /usr/databases/live/base1.d6 f 500000
d /usr/databases/live/base1.d7 f 500000
d /usr/databases/live/base1.d8 f 500000
d /usr/databases/live/base1.d9
b /usr/databases/live/base1.b1
Now you can make few decision on ur own based on ur disk space. This configuration will hog almost 4GB + future growth of ur space. Similarly how many extents u need to define thats also entirely ur decision. Location of bi file is also upon you.
Back to the tutorial. Save this base1.st file in the same directory /usr/databases/live/.
4. run the command "prostrct create base1" this command will create a MV db structure which is void, u will see the status of this command as extents being created.
5. now Last step:- "procopy /usr/databases/live/dbbakup/base1 /usr/databases/live/base1"
this will copy single volume backedup base1 DB in to newly created MV base1 DB.
This utility will give u status in %.
I suggest you also read SAG from progress to get more understanding of how these things are done. Though my instructions will help you convert ur Single DB to MV DB.