I/O Error

[Elvis]

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

 

[cecsno]

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.

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

 

[Elvis]

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.............

 

[cecsno]

You have a single volume database (base1.db) it has reach 2 gig, it needs to be converted to a multi-volume database.

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.............

 

[Elvis]

how do I convert her to multivolume?

 

[Krokodile]

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.