Informix

Dear All:

I'm asking you about this because I made a copy of an Informix server with ontape to import it into a PC for convenience and security reasons (avoid working with real data).

On the PC I installed Informix 7.31 TD6 for Windows, which is the same version as the server, I created the same dbspaces on the same disk drives as the server, and I also named the chunks the same on both computers. I also made sure to create the dbspaces in the same order and obviously respecting their size. Also the ONCONFIG is the same for both.

The only difference is the operating system, since the server has a 32-bit Windows 2008 server, while the PC has a 64-bit Windows 10.

When I want to do ontape -r, it shows me everything that has been backed up and asks me if I want to restore, which I confirm of course, but after accepting, the command window remains without showing anything for about 15 or so. 20 minutes, and finally it informs me that it cannot connect to the server.

I clarify that also on the PC I changed the INFORMIXDIR, INFORMIXSERVER and ONCONFIG environment variables so that they remained the same.

Has anyone been able to do what I can't?

I thank you in advance for your kindness and time.

Gustavo Echenique.

Gustavo:

It sounds like you configured and started an Informix instance on the new box. Neither ontape nor onarchive will perform a full restore to a running instance. You could only restore single dbspaces to a running instance. So here is what you do:

1. Make sure that the SERVERNAME on the new box is the same as the source server was/is. 
2. Make sure that TAPEDEV is pointed to the archive file.
3. Make sure that TAPEBLOCK is the same as it was when the archive was created.
4. Take the running instance offline (onmode -ky).
5. Restore: ontape -r

Art

Dear All:

I'm asking you about this because I made a copy of an Informix server with ontape to import it into a PC for convenience and security reasons (avoid working with real data).

On the PC I installed Informix 7.31 TD6 for Windows, which is the same version as the server, I created the same dbspaces on the same disk drives as the server, and I also named the chunks the same on both computers. I also made sure to create the dbspaces in the same order and obviously respecting their size. Also the ONCONFIG is the same for both.

The only difference is the operating system, since the server has a 32-bit Windows 2008 server, while the PC has a 64-bit Windows 10.

When I want to do ontape -r, it shows me everything that has been backed up and asks me if I want to restore, which I confirm of course, but after accepting, the command window remains without showing anything for about 15 or so. 20 minutes, and finally it informs me that it cannot connect to the server.

I clarify that also on the PC I changed the INFORMIXDIR, INFORMIXSERVER and ONCONFIG environment variables so that they remained the same.

Has anyone been able to do what I can't?

I thank you in advance for your kindness and time.

Gustavo Echenique.

Dear Art:

When I ran the ontape, I made sure to turn down the motor with onmode -ky.

What raises doubts in my mind is that on the server the drive where the backup is recorded is mapped as W:, but on the PC it is as E: . Could this have something to do with it?

Gustavo:

It sounds like you configured and started an Informix instance on the new box. Neither ontape nor onarchive will perform a full restore to a running instance. You could only restore single dbspaces to a running instance. So here is what you do:

1. Make sure that the SERVERNAME on the new box is the same as the source server was/is. 
2. Make sure that TAPEDEV is pointed to the archive file.
3. Make sure that TAPEBLOCK is the same as it was when the archive was created.
4. Take the running instance offline (onmode -ky).
5. Restore: ontape -r

Art

Dear All:

I'm asking you about this because I made a copy of an Informix server with ontape to import it into a PC for convenience and security reasons (avoid working with real data).

On the PC I installed Informix 7.31 TD6 for Windows, which is the same version as the server, I created the same dbspaces on the same disk drives as the server, and I also named the chunks the same on both computers. I also made sure to create the dbspaces in the same order and obviously respecting their size. Also the ONCONFIG is the same for both.

The only difference is the operating system, since the server has a 32-bit Windows 2008 server, while the PC has a 64-bit Windows 10.

When I want to do ontape -r, it shows me everything that has been backed up and asks me if I want to restore, which I confirm of course, but after accepting, the command window remains without showing anything for about 15 or so. 20 minutes, and finally it informs me that it cannot connect to the server.

I clarify that also on the PC I changed the INFORMIXDIR, INFORMIXSERVER and ONCONFIG environment variables so that they remained the same.

Has anyone been able to do what I can't?

I thank you in advance for your kindness and time.

Gustavo Echenique.

Dear Art:

When I ran the ontape, I made sure to turn down the motor with onmode -ky.

What raises doubts in my mind is that on the server the drive where the backup is recorded is mapped as W:, but on the PC it is as E: . Could this have something to do with it?

Gustavo:

It sounds like you configured and started an Informix instance on the new box. Neither ontape nor onarchive will perform a full restore to a running instance. You could only restore single dbspaces to a running instance. So here is what you do:

1. Make sure that the SERVERNAME on the new box is the same as the source server was/is. 
2. Make sure that TAPEDEV is pointed to the archive file.
3. Make sure that TAPEBLOCK is the same as it was when the archive was created.
4. Take the running instance offline (onmode -ky).
5. Restore: ontape -r

Art

Dear All:

I'm asking you about this because I made a copy of an Informix server with ontape to import it into a PC for convenience and security reasons (avoid working with real data).

On the PC I installed Informix 7.31 TD6 for Windows, which is the same version as the server, I created the same dbspaces on the same disk drives as the server, and I also named the chunks the same on both computers. I also made sure to create the dbspaces in the same order and obviously respecting their size. Also the ONCONFIG is the same for both.

The only difference is the operating system, since the server has a 32-bit Windows 2008 server, while the PC has a 64-bit Windows 10.

When I want to do ontape -r, it shows me everything that has been backed up and asks me if I want to restore, which I confirm of course, but after accepting, the command window remains without showing anything for about 15 or so. 20 minutes, and finally it informs me that it cannot connect to the server.

I clarify that also on the PC I changed the INFORMIXDIR, INFORMIXSERVER and ONCONFIG environment variables so that they remained the same.

Has anyone been able to do what I can't?

I thank you in advance for your kindness and time.

Gustavo Echenique.

Dear Art:

When I ran the ontape, I made sure to turn down the motor with onmode -ky.

What raises doubts in my mind is that on the server the drive where the backup is recorded is mapped as W:, but on the PC it is as E: . Could this have something to do with it?

Gustavo:

It sounds like you configured and started an Informix instance on the new box. Neither ontape nor onarchive will perform a full restore to a running instance. You could only restore single dbspaces to a running instance. So here is what you do:

1. Make sure that the SERVERNAME on the new box is the same as the source server was/is. 
2. Make sure that TAPEDEV is pointed to the archive file.
3. Make sure that TAPEBLOCK is the same as it was when the archive was created.
4. Take the running instance offline (onmode -ky).
5. Restore: ontape -r

Art

Dear All:

I'm asking you about this because I made a copy of an Informix server with ontape to import it into a PC for convenience and security reasons (avoid working with real data).

On the PC I installed Informix 7.31 TD6 for Windows, which is the same version as the server, I created the same dbspaces on the same disk drives as the server, and I also named the chunks the same on both computers. I also made sure to create the dbspaces in the same order and obviously respecting their size. Also the ONCONFIG is the same for both.

The only difference is the operating system, since the server has a 32-bit Windows 2008 server, while the PC has a 64-bit Windows 10.

When I want to do ontape -r, it shows me everything that has been backed up and asks me if I want to restore, which I confirm of course, but after accepting, the command window remains without showing anything for about 15 or so. 20 minutes, and finally it informs me that it cannot connect to the server.

I clarify that also on the PC I changed the INFORMIXDIR, INFORMIXSERVER and ONCONFIG environment variables so that they remained the same.

Has anyone been able to do what I can't?

I thank you in advance for your kindness and time.

Gustavo Echenique.

Dear All:

I'm asking you about this because I made a copy of an Informix server with ontape to import it into a PC for convenience and security reasons (avoid working with real data).

On the PC I installed Informix 7.31 TD6 for Windows, which is the same version as the server, I created the same dbspaces on the same disk drives as the server, and I also named the chunks the same on both computers. I also made sure to create the dbspaces in the same order and obviously respecting their size. Also the ONCONFIG is the same for both.

The only difference is the operating system, since the server has a 32-bit Windows 2008 server, while the PC has a 64-bit Windows 10.

When I want to do ontape -r, it shows me everything that has been backed up and asks me if I want to restore, which I confirm of course, but after accepting, the command window remains without showing anything for about 15 or so. 20 minutes, and finally it informs me that it cannot connect to the server.

I clarify that also on the PC I changed the INFORMIXDIR, INFORMIXSERVER and ONCONFIG environment variables so that they remained the same.

Has anyone been able to do what I can't?

I thank you in advance for your kindness and time.

Gustavo Echenique.

Dear All:

I'm asking you about this because I made a copy of an Informix server with ontape to import it into a PC for convenience and security reasons (avoid working with real data).

On the PC I installed Informix 7.31 TD6 for Windows, which is the same version as the server, I created the same dbspaces on the same disk drives as the server, and I also named the chunks the same on both computers. I also made sure to create the dbspaces in the same order and obviously respecting their size. Also the ONCONFIG is the same for both.

The only difference is the operating system, since the server has a 32-bit Windows 2008 server, while the PC has a 64-bit Windows 10.

When I want to do ontape -r, it shows me everything that has been backed up and asks me if I want to restore, which I confirm of course, but after accepting, the command window remains without showing anything for about 15 or so. 20 minutes, and finally it informs me that it cannot connect to the server.

I clarify that also on the PC I changed the INFORMIXDIR, INFORMIXSERVER and ONCONFIG environment variables so that they remained the same.

Has anyone been able to do what I can't?

I thank you in advance for your kindness and time.

Gustavo Echenique.

Dear All:

I'm asking you about this because I made a copy of an Informix server with ontape to import it into a PC for convenience and security reasons (avoid working with real data).

On the PC I installed Informix 7.31 TD6 for Windows, which is the same version as the server, I created the same dbspaces on the same disk drives as the server, and I also named the chunks the same on both computers. I also made sure to create the dbspaces in the same order and obviously respecting their size. Also the ONCONFIG is the same for both.

The only difference is the operating system, since the server has a 32-bit Windows 2008 server, while the PC has a 64-bit Windows 10.

When I want to do ontape -r, it shows me everything that has been backed up and asks me if I want to restore, which I confirm of course, but after accepting, the command window remains without showing anything for about 15 or so. 20 minutes, and finally it informs me that it cannot connect to the server.

I clarify that also on the PC I changed the INFORMIXDIR, INFORMIXSERVER and ONCONFIG environment variables so that they remained the same.

Has anyone been able to do what I can't?

I thank you in advance for your kindness and time.

Gustavo Echenique.

I've already checked everything, and it doesn't work.

Now he also does not raise the case. Obviously the ontape has restored the logical logs but cannot do the physical restoration.

Dear All:

I'm asking you about this because I made a copy of an Informix server with ontape to import it into a PC for convenience and security reasons (avoid working with real data).

On the PC I installed Informix 7.31 TD6 for Windows, which is the same version as the server, I created the same dbspaces on the same disk drives as the server, and I also named the chunks the same on both computers. I also made sure to create the dbspaces in the same order and obviously respecting their size. Also the ONCONFIG is the same for both.

The only difference is the operating system, since the server has a 32-bit Windows 2008 server, while the PC has a 64-bit Windows 10.

When I want to do ontape -r, it shows me everything that has been backed up and asks me if I want to restore, which I confirm of course, but after accepting, the command window remains without showing anything for about 15 or so. 20 minutes, and finally it informs me that it cannot connect to the server.

I clarify that also on the PC I changed the INFORMIXDIR, INFORMIXSERVER and ONCONFIG environment variables so that they remained the same.

Has anyone been able to do what I can't?

I thank you in advance for your kindness and time.

Gustavo Echenique.

Dear All:

I'm asking you about this because I made a copy of an Informix server with ontape to import it into a PC for convenience and security reasons (avoid working with real data).

On the PC I installed Informix 7.31 TD6 for Windows, which is the same version as the server, I created the same dbspaces on the same disk drives as the server, and I also named the chunks the same on both computers. I also made sure to create the dbspaces in the same order and obviously respecting their size. Also the ONCONFIG is the same for both.

The only difference is the operating system, since the server has a 32-bit Windows 2008 server, while the PC has a 64-bit Windows 10.

When I want to do ontape -r, it shows me everything that has been backed up and asks me if I want to restore, which I confirm of course, but after accepting, the command window remains without showing anything for about 15 or so. 20 minutes, and finally it informs me that it cannot connect to the server.

I clarify that also on the PC I changed the INFORMIXDIR, INFORMIXSERVER and ONCONFIG environment variables so that they remained the same.

Has anyone been able to do what I can't?

I thank you in advance for your kindness and time.

Gustavo Echenique.

Yes, of course Paul, but the "-i" switch will unbind the dbspaces for me, won't it?

Dear All:

I'm asking you about this because I made a copy of an Informix server with ontape to import it into a PC for convenience and security reasons (avoid working with real data).

On the PC I installed Informix 7.31 TD6 for Windows, which is the same version as the server, I created the same dbspaces on the same disk drives as the server, and I also named the chunks the same on both computers. I also made sure to create the dbspaces in the same order and obviously respecting their size. Also the ONCONFIG is the same for both.

The only difference is the operating system, since the server has a 32-bit Windows 2008 server, while the PC has a 64-bit Windows 10.

When I want to do ontape -r, it shows me everything that has been backed up and asks me if I want to restore, which I confirm of course, but after accepting, the command window remains without showing anything for about 15 or so. 20 minutes, and finally it informs me that it cannot connect to the server.

I clarify that also on the PC I changed the INFORMIXDIR, INFORMIXSERVER and ONCONFIG environment variables so that they remained the same.

Has anyone been able to do what I can't?

I thank you in advance for your kindness and time.

Gustavo Echenique.

Yes, of course Paul, but the "-i" switch will unbind the dbspaces for me, won't it?

Dear All:

I'm asking you about this because I made a copy of an Informix server with ontape to import it into a PC for convenience and security reasons (avoid working with real data).

On the PC I installed Informix 7.31 TD6 for Windows, which is the same version as the server, I created the same dbspaces on the same disk drives as the server, and I also named the chunks the same on both computers. I also made sure to create the dbspaces in the same order and obviously respecting their size. Also the ONCONFIG is the same for both.

The only difference is the operating system, since the server has a 32-bit Windows 2008 server, while the PC has a 64-bit Windows 10.

When I want to do ontape -r, it shows me everything that has been backed up and asks me if I want to restore, which I confirm of course, but after accepting, the command window remains without showing anything for about 15 or so. 20 minutes, and finally it informs me that it cannot connect to the server.

I clarify that also on the PC I changed the INFORMIXDIR, INFORMIXSERVER and ONCONFIG environment variables so that they remained the same.

Has anyone been able to do what I can't?

I thank you in advance for your kindness and time.

Gustavo Echenique.

Yes, of course Paul, but the "-i" switch will unbind the dbspaces for me, won't it?

Dear All:

I'm asking you about this because I made a copy of an Informix server with ontape to import it into a PC for convenience and security reasons (avoid working with real data).

On the PC I installed Informix 7.31 TD6 for Windows, which is the same version as the server, I created the same dbspaces on the same disk drives as the server, and I also named the chunks the same on both computers. I also made sure to create the dbspaces in the same order and obviously respecting their size. Also the ONCONFIG is the same for both.

The only difference is the operating system, since the server has a 32-bit Windows 2008 server, while the PC has a 64-bit Windows 10.

When I want to do ontape -r, it shows me everything that has been backed up and asks me if I want to restore, which I confirm of course, but after accepting, the command window remains without showing anything for about 15 or so. 20 minutes, and finally it informs me that it cannot connect to the server.

I clarify that also on the PC I changed the INFORMIXDIR, INFORMIXSERVER and ONCONFIG environment variables so that they remained the same.

Has anyone been able to do what I can't?

I thank you in advance for your kindness and time.

Gustavo Echenique.

I have tried starting the server with the -i switch but it has no effect.
Sometimes it cuts off in the initialization phase, and other times in the Fast Recovery phase, but it always ends up warning that the shared memory could not be initialized.

Yes, of course Paul, but the "-i" switch will unbind the dbspaces for me, won't it?

Dear All:

I'm asking you about this because I made a copy of an Informix server with ontape to import it into a PC for convenience and security reasons (avoid working with real data).

On the PC I installed Informix 7.31 TD6 for Windows, which is the same version as the server, I created the same dbspaces on the same disk drives as the server, and I also named the chunks the same on both computers. I also made sure to create the dbspaces in the same order and obviously respecting their size. Also the ONCONFIG is the same for both.

The only difference is the operating system, since the server has a 32-bit Windows 2008 server, while the PC has a 64-bit Windows 10.

When I want to do ontape -r, it shows me everything that has been backed up and asks me if I want to restore, which I confirm of course, but after accepting, the command window remains without showing anything for about 15 or so. 20 minutes, and finally it informs me that it cannot connect to the server.

I clarify that also on the PC I changed the INFORMIXDIR, INFORMIXSERVER and ONCONFIG environment variables so that they remained the same.

Has anyone been able to do what I can't?

I thank you in advance for your kindness and time.

Gustavo Echenique.

Gustavo:

Post the following and we'll see what we can see:

• The last 30 lines from the message log.
• Your sqlhosts file.
• The server's host's name or IP address (whichever you used in the sqlhosts file)
• You ONCONFIG file.

If we don't see what the issue is, someone will have to look at your system live (via Zoom?) and that will likely be a chargeable consultation. I could do that for you if needed as can several others on this forum. Hopefully we will see the issue and you will be on your way.

Art

I have tried starting the server with the -i switch but it has no effect.
Sometimes it cuts off in the initialization phase, and other times in the Fast Recovery phase, but it always ends up warning that the shared memory could not be initialized.

Yes, of course Paul, but the "-i" switch will unbind the dbspaces for me, won't it?

Dear All:

I'm asking you about this because I made a copy of an Informix server with ontape to import it into a PC for convenience and security reasons (avoid working with real data).

On the PC I installed Informix 7.31 TD6 for Windows, which is the same version as the server, I created the same dbspaces on the same disk drives as the server, and I also named the chunks the same on both computers. I also made sure to create the dbspaces in the same order and obviously respecting their size. Also the ONCONFIG is the same for both.

The only difference is the operating system, since the server has a 32-bit Windows 2008 server, while the PC has a 64-bit Windows 10.

When I want to do ontape -r, it shows me everything that has been backed up and asks me if I want to restore, which I confirm of course, but after accepting, the command window remains without showing anything for about 15 or so. 20 minutes, and finally it informs me that it cannot connect to the server.

I clarify that also on the PC I changed the INFORMIXDIR, INFORMIXSERVER and ONCONFIG environment variables so that they remained the same.

Has anyone been able to do what I can't?

I thank you in advance for your kindness and time.

Gustavo Echenique.

Hello Art!

I've been building a new Informix 7.31 TD6 engine for Windows all this week in my little free time.

I have configured everything according to the Informix manuals, and I think everything is fine.

I say estimate, because last night I tried again and it gave me the sad error message: "Physical restore failed - could not fork server connection".

In your last message you asked me for a copy of the sqlhosts file, but there is no file with that name in Windows, I had come to think that it only worked on Unix or Linux.

But then in the Informix manuals for Windows NT, in the backup and restore chapter it talks about saving the sqlhosts.

Is the sqlhosts file necessary in an Informix installation on Windows?

Can the lack of it cause Ontape to abort the restoration?

Gustavo:

Post the following and we'll see what we can see:

• The last 30 lines from the message log.
• Your sqlhosts file.
• The server's host's name or IP address (whichever you used in the sqlhosts file)
• You ONCONFIG file.

If we don't see what the issue is, someone will have to look at your system live (via Zoom?) and that will likely be a chargeable consultation. I could do that for you if needed as can several others on this forum. Hopefully we will see the issue and you will be on your way.

Art

I have tried starting the server with the -i switch but it has no effect.
Sometimes it cuts off in the initialization phase, and other times in the Fast Recovery phase, but it always ends up warning that the shared memory could not be initialized.

Yes, of course Paul, but the "-i" switch will unbind the dbspaces for me, won't it?

Dear All:

I'm asking you about this because I made a copy of an Informix server with ontape to import it into a PC for convenience and security reasons (avoid working with real data).

On the PC I installed Informix 7.31 TD6 for Windows, which is the same version as the server, I created the same dbspaces on the same disk drives as the server, and I also named the chunks the same on both computers. I also made sure to create the dbspaces in the same order and obviously respecting their size. Also the ONCONFIG is the same for both.

The only difference is the operating system, since the server has a 32-bit Windows 2008 server, while the PC has a 64-bit Windows 10.

When I want to do ontape -r, it shows me everything that has been backed up and asks me if I want to restore, which I confirm of course, but after accepting, the command window remains without showing anything for about 15 or so. 20 minutes, and finally it informs me that it cannot connect to the server.

I clarify that also on the PC I changed the INFORMIXDIR, INFORMIXSERVER and ONCONFIG environment variables so that they remained the same.

Has anyone been able to do what I can't?

I thank you in advance for your kindness and time.

Gustavo Echenique.

Hello Art!

I've been building a new Informix 7.31 TD6 engine for Windows all this week in my little free time.

I have configured everything according to the Informix manuals, and I think everything is fine.

I say estimate, because last night I tried again and it gave me the sad error message: "Physical restore failed - could not fork server connection".

In your last message you asked me for a copy of the sqlhosts file, but there is no file with that name in Windows, I had come to think that it only worked on Unix or Linux.

But then in the Informix manuals for Windows NT, in the backup and restore chapter it talks about saving the sqlhosts.

Is the sqlhosts file necessary in an Informix installation on Windows?

Can the lack of it cause Ontape to abort the restoration?

Gustavo:

Post the following and we'll see what we can see:

• The last 30 lines from the message log.
• Your sqlhosts file.
• The server's host's name or IP address (whichever you used in the sqlhosts file)
• You ONCONFIG file.

If we don't see what the issue is, someone will have to look at your system live (via Zoom?) and that will likely be a chargeable consultation. I could do that for you if needed as can several others on this forum. Hopefully we will see the issue and you will be on your way.

Art

I have tried starting the server with the -i switch but it has no effect.
Sometimes it cuts off in the initialization phase, and other times in the Fast Recovery phase, but it always ends up warning that the shared memory could not be initialized.

Yes, of course Paul, but the "-i" switch will unbind the dbspaces for me, won't it?

Dear All:

I'm asking you about this because I made a copy of an Informix server with ontape to import it into a PC for convenience and security reasons (avoid working with real data).

On the PC I installed Informix 7.31 TD6 for Windows, which is the same version as the server, I created the same dbspaces on the same disk drives as the server, and I also named the chunks the same on both computers. I also made sure to create the dbspaces in the same order and obviously respecting their size. Also the ONCONFIG is the same for both.

The only difference is the operating system, since the server has a 32-bit Windows 2008 server, while the PC has a 64-bit Windows 10.

When I want to do ontape -r, it shows me everything that has been backed up and asks me if I want to restore, which I confirm of course, but after accepting, the command window remains without showing anything for about 15 or so. 20 minutes, and finally it informs me that it cannot connect to the server.

I clarify that also on the PC I changed the INFORMIXDIR, INFORMIXSERVER and ONCONFIG environment variables so that they remained the same.

Has anyone been able to do what I can't?

I thank you in advance for your kindness and time.

Gustavo Echenique.

Hello Art!

I've been building a new Informix 7.31 TD6 engine for Windows all this week in my little free time.

I have configured everything according to the Informix manuals, and I think everything is fine.

I say estimate, because last night I tried again and it gave me the sad error message: "Physical restore failed - could not fork server connection".

In your last message you asked me for a copy of the sqlhosts file, but there is no file with that name in Windows, I had come to think that it only worked on Unix or Linux.

But then in the Informix manuals for Windows NT, in the backup and restore chapter it talks about saving the sqlhosts.

Is the sqlhosts file necessary in an Informix installation on Windows?

Can the lack of it cause Ontape to abort the restoration?

Gustavo:

Post the following and we'll see what we can see:

• The last 30 lines from the message log.
• Your sqlhosts file.
• The server's host's name or IP address (whichever you used in the sqlhosts file)
• You ONCONFIG file.

If we don't see what the issue is, someone will have to look at your system live (via Zoom?) and that will likely be a chargeable consultation. I could do that for you if needed as can several others on this forum. Hopefully we will see the issue and you will be on your way.

Art

I have tried starting the server with the -i switch but it has no effect.
Sometimes it cuts off in the initialization phase, and other times in the Fast Recovery phase, but it always ends up warning that the shared memory could not be initialized.

Yes, of course Paul, but the "-i" switch will unbind the dbspaces for me, won't it?

Dear All:

I'm asking you about this because I made a copy of an Informix server with ontape to import it into a PC for convenience and security reasons (avoid working with real data).

On the PC I installed Informix 7.31 TD6 for Windows, which is the same version as the server, I created the same dbspaces on the same disk drives as the server, and I also named the chunks the same on both computers. I also made sure to create the dbspaces in the same order and obviously respecting their size. Also the ONCONFIG is the same for both.

The only difference is the operating system, since the server has a 32-bit Windows 2008 server, while the PC has a 64-bit Windows 10.

When I want to do ontape -r, it shows me everything that has been backed up and asks me if I want to restore, which I confirm of course, but after accepting, the command window remains without showing anything for about 15 or so. 20 minutes, and finally it informs me that it cannot connect to the server.

I clarify that also on the PC I changed the INFORMIXDIR, INFORMIXSERVER and ONCONFIG environment variables so that they remained the same.

Has anyone been able to do what I can't?

I thank you in advance for your kindness and time.

Gustavo Echenique.

Hello Art!

I've been building a new Informix 7.31 TD6 engine for Windows all this week in my little free time.

I have configured everything according to the Informix manuals, and I think everything is fine.

I say estimate, because last night I tried again and it gave me the sad error message: "Physical restore failed - could not fork server connection".

In your last message you asked me for a copy of the sqlhosts file, but there is no file with that name in Windows, I had come to think that it only worked on Unix or Linux.

But then in the Informix manuals for Windows NT, in the backup and restore chapter it talks about saving the sqlhosts.

Is the sqlhosts file necessary in an Informix installation on Windows?

Can the lack of it cause Ontape to abort the restoration?

Gustavo:

Post the following and we'll see what we can see:

• The last 30 lines from the message log.
• Your sqlhosts file.
• The server's host's name or IP address (whichever you used in the sqlhosts file)
• You ONCONFIG file.

If we don't see what the issue is, someone will have to look at your system live (via Zoom?) and that will likely be a chargeable consultation. I could do that for you if needed as can several others on this forum. Hopefully we will see the issue and you will be on your way.

Art

I have tried starting the server with the -i switch but it has no effect.
Sometimes it cuts off in the initialization phase, and other times in the Fast Recovery phase, but it always ends up warning that the shared memory could not be initialized.

Yes, of course Paul, but the "-i" switch will unbind the dbspaces for me, won't it?

Dear All:

I'm asking you about this because I made a copy of an Informix server with ontape to import it into a PC for convenience and security reasons (avoid working with real data).

On the PC I installed Informix 7.31 TD6 for Windows, which is the same version as the server, I created the same dbspaces on the same disk drives as the server, and I also named the chunks the same on both computers. I also made sure to create the dbspaces in the same order and obviously respecting their size. Also the ONCONFIG is the same for both.

The only difference is the operating system, since the server has a 32-bit Windows 2008 server, while the PC has a 64-bit Windows 10.

When I want to do ontape -r, it shows me everything that has been backed up and asks me if I want to restore, which I confirm of course, but after accepting, the command window remains without showing anything for about 15 or so. 20 minutes, and finally it informs me that it cannot connect to the server.

I clarify that also on the PC I changed the INFORMIXDIR, INFORMIXSERVER and ONCONFIG environment variables so that they remained the same.

Has anyone been able to do what I can't?

I thank you in advance for your kindness and time.

Gustavo Echenique.

I have tried starting the server with the -i switch but it has no effect.
Sometimes it cuts off in the initialization phase, and other times in the Fast Recovery phase, but it always ends up warning that the shared memory could not be initialized.

Yes, of course Paul, but the "-i" switch will unbind the dbspaces for me, won't it?

Dear All:

I'm asking you about this because I made a copy of an Informix server with ontape to import it into a PC for convenience and security reasons (avoid working with real data).

On the PC I installed Informix 7.31 TD6 for Windows, which is the same version as the server, I created the same dbspaces on the same disk drives as the server, and I also named the chunks the same on both computers. I also made sure to create the dbspaces in the same order and obviously respecting their size. Also the ONCONFIG is the same for both.

The only difference is the operating system, since the server has a 32-bit Windows 2008 server, while the PC has a 64-bit Windows 10.

When I want to do ontape -r, it shows me everything that has been backed up and asks me if I want to restore, which I confirm of course, but after accepting, the command window remains without showing anything for about 15 or so. 20 minutes, and finally it informs me that it cannot connect to the server.

I clarify that also on the PC I changed the INFORMIXDIR, INFORMIXSERVER and ONCONFIG environment variables so that they remained the same.

Has anyone been able to do what I can't?

I thank you in advance for your kindness and time.

Gustavo Echenique.

Yes, of course Paul, but the "-i" switch will unbind the dbspaces for me, won't it?

Dear All:

I'm asking you about this because I made a copy of an Informix server with ontape to import it into a PC for convenience and security reasons (avoid working with real data).

On the PC I installed Informix 7.31 TD6 for Windows, which is the same version as the server, I created the same dbspaces on the same disk drives as the server, and I also named the chunks the same on both computers. I also made sure to create the dbspaces in the same order and obviously respecting their size. Also the ONCONFIG is the same for both.

The only difference is the operating system, since the server has a 32-bit Windows 2008 server, while the PC has a 64-bit Windows 10.

When I want to do ontape -r, it shows me everything that has been backed up and asks me if I want to restore, which I confirm of course, but after accepting, the command window remains without showing anything for about 15 or so. 20 minutes, and finally it informs me that it cannot connect to the server.

I clarify that also on the PC I changed the INFORMIXDIR, INFORMIXSERVER and ONCONFIG environment variables so that they remained the same.

Has anyone been able to do what I can't?

I thank you in advance for your kindness and time.

Gustavo Echenique.

Hi Marcus.

The online.log tells me that it cannot find the log and that it cannot do a rollforward, nothing more than that.

Yes, of course Paul, but the "-i" switch will unbind the dbspaces for me, won't it?

Dear All:

I'm asking you about this because I made a copy of an Informix server with ontape to import it into a PC for convenience and security reasons (avoid working with real data).

On the PC I installed Informix 7.31 TD6 for Windows, which is the same version as the server, I created the same dbspaces on the same disk drives as the server, and I also named the chunks the same on both computers. I also made sure to create the dbspaces in the same order and obviously respecting their size. Also the ONCONFIG is the same for both.

The only difference is the operating system, since the server has a 32-bit Windows 2008 server, while the PC has a 64-bit Windows 10.

When I want to do ontape -r, it shows me everything that has been backed up and asks me if I want to restore, which I confirm of course, but after accepting, the command window remains without showing anything for about 15 or so. 20 minutes, and finally it informs me that it cannot connect to the server.

I clarify that also on the PC I changed the INFORMIXDIR, INFORMIXSERVER and ONCONFIG environment variables so that they remained the same.

Has anyone been able to do what I can't?

I thank you in advance for your kindness and time.

Gustavo Echenique.

Yes, of course Paul, but the "-i" switch will unbind the dbspaces for me, won't it?

Dear All:

I'm asking you about this because I made a copy of an Informix server with ontape to import it into a PC for convenience and security reasons (avoid working with real data).

On the PC I installed Informix 7.31 TD6 for Windows, which is the same version as the server, I created the same dbspaces on the same disk drives as the server, and I also named the chunks the same on both computers. I also made sure to create the dbspaces in the same order and obviously respecting their size. Also the ONCONFIG is the same for both.

The only difference is the operating system, since the server has a 32-bit Windows 2008 server, while the PC has a 64-bit Windows 10.

When I want to do ontape -r, it shows me everything that has been backed up and asks me if I want to restore, which I confirm of course, but after accepting, the command window remains without showing anything for about 15 or so. 20 minutes, and finally it informs me that it cannot connect to the server.

I clarify that also on the PC I changed the INFORMIXDIR, INFORMIXSERVER and ONCONFIG environment variables so that they remained the same.

Has anyone been able to do what I can't?

I thank you in advance for your kindness and time.

Gustavo Echenique.

Hi Art

When starting the restoration it asks me if I want to make a backup of the logs, and I answered yes the first time.
If so, I may have damaged the instance, and now if I answer yes or no, it doesn't matter, it tells me that it cannot connect to the engine and in the online.log it tells me that it cannot find the logical log to do a rollforward and lower the instance.

Yes, of course Paul, but the "-i" switch will unbind the dbspaces for me, won't it?

Dear All:

I'm asking you about this because I made a copy of an Informix server with ontape to import it into a PC for convenience and security reasons (avoid working with real data).

On the PC I installed Informix 7.31 TD6 for Windows, which is the same version as the server, I created the same dbspaces on the same disk drives as the server, and I also named the chunks the same on both computers. I also made sure to create the dbspaces in the same order and obviously respecting their size. Also the ONCONFIG is the same for both.

The only difference is the operating system, since the server has a 32-bit Windows 2008 server, while the PC has a 64-bit Windows 10.

When I want to do ontape -r, it shows me everything that has been backed up and asks me if I want to restore, which I confirm of course, but after accepting, the command window remains without showing anything for about 15 or so. 20 minutes, and finally it informs me that it cannot connect to the server.

I clarify that also on the PC I changed the INFORMIXDIR, INFORMIXSERVER and ONCONFIG environment variables so that they remained the same.

Has anyone been able to do what I can't?

I thank you in advance for your kindness and time.

Gustavo Echenique.