Appendix

Troubleshooting

Initialization process for IDS v9.30

If you are installing IDS v9.40, v10.00 or IDS v9.30 on Windows 2000, skip this section.

Creating the DbSpace

Thus the database engine is running, as the automatic installation process failed, there is no other DbSpace than the rootdbs. If you go to C:\IFMXDATA\ol_scoobidoo2ifmx, you will see that the files are there but nothing is initialized.

C:\IFMXDATA\ol_scoobidoo2ifmx>dir
Volume in drive C has no label.
Volume Serial Number is 306A-4E8E

Directory of C:\IFMXDATA\ol_scoobidoo2ifmx

2002/11/23 15:43 <DIR>       .
2002/11/23 15:43 <DIR>       ..
2002/11/23 15:43           0 dbs_scoobidoo2ifmx_dat.000
2002/11/23 15:58  52 428 800 rootdbs_dat.000
2002/11/23 15:43           0 sbspace_dat.000
  3 File(s)      52 428 800 bytes
  2 Dir(s)   14 095 757 312 bytes free

We can use the Informix onspaces command to create what we need.

Running onspaces

The onspaces command will help us create the missing DbSpace. To run onspaces, we are going to run a special Command Prompt, the one created by the Informix setup program. Click on the “Start” button, go to “All Programs”, “Informix Dynamic Server 9.30” and click on “ol_scoobidoo2ifmx”.

onspaces command line for creating the DbSpace:

onspaces
 -c
 -d dbs_popeye
 -p C:\IFMXDATA\ol_scoobidoo2ifmx\dbs_scoobidoo2ifmx_dat.000
 -o 0
 -s 50000

Quick explanation:

  •  -c is used for creating.
  •  -d followed by dbs_popeye specifies the name of the DbSpace.
  •  -p sets the path, note that the path and file already exist.
  •  -o sets the offset at the beginning of the file this is mostly used when using raw devices.
  •  -s defines the size of the DbSpace, as we decided for 50 Mb earlier, here the DbSpace size is defined as 50,000 Kb.

Running onspaces for creating the DbSpace:

C:\Informix>onspaces -c -d dbs_scoobidoo2ifmx -p C:\IFMXDATA\ol_scoobidoo2ifmx\dbs_scoobidoo2ifmx_dat.000 -o 0 -s 50000
 Verifying physical disk space, please wait ...
 Space successfully added.

** WARNING ** A level 0 archive of Root DBSpace will need to be done.

If you recall well, we also wanted to create a Smart BLOB Space. This one as well was not completed successfully.

onspaces command line for creating the Smart BLOB Space:

onspaces
 -c
 -S sbspace
 -p C:\IFMXDATA\ol_scoobidoo2ifmx\sbspace_dat.000
 -o 0
 -s 50000

Quick explanation:

  • -c is used for creating.
  • -S followed by sbspace specifies the name of the smart BLOB space.
  • -p sets the path, note that the path and file already exist.
  • -o sets the offset at the beginning of the file this is mostly used when using raw devices.
  • -s defines the size of the smart BLOB space, as we decided for 50 Mb earlier, here its size is defined as 50,000 Kb.

Running onspaces for creating the Smart BLOB Space:

C:\Informix>onspaces -c -S sbspace -p C:\IFMXDATA\ol_scoobidoo2ifmx\sbspace_dat.000 -o 0 -s 50000
 Verifying physical disk space, please wait ...
 Space successfully added.

** WARNING ** A level 0 archive of Root DBSpace will need to be done.

A quick check can be done by going to the directory and listing its files, as in the following listing.

C:\Informix>cd C:\IFMXDATA\ol_scoobidoo2ifmx

C:\IFMXDATA\ol_scoobidoo2ifmx>dir
 Volume in drive C has no label.
 Volume Serial Number is 306A-4E8E

Directory of C:\IFMXDATA\ol_scoobidoo2ifmx

 2002/11/23 15:43 <DIR>      .
 2002/11/23 15:43 <DIR>      ..
 2002/11/25 09:09 51 200 000 dbs_scoobidoo2ifmx_dat.000
 2002/11/23 15:58 52 428 800 rootdbs_dat.000
 2002/11/25 09:40 51 200 000 sbspace_dat.000
 3 File(s)     113 868 800 bytes
 2 Dir(s)   13 993 553 920 bytes free

Microsoft Antispyware

If you are using Microsoft Antispyware, update to Microsoft Windows Defender or be careful about potential pop-up that might occur. Simply click on “Allow” and be sure to have the “Remember this action” checkbox checked.

Microsoft Antispyware blocking msgserv.exe.
Microsoft Antispyware blocking msgserv.exe.
Microsoft Antispyware blocking onscpah.exe.
Microsoft Antispyware blocking onscpah.exe.

Resources

Web

Books and Manual

  • IBM Informix DB-Access User’s Guide (G251-2277-00).
  • IBM Informix Dynamic Server Administrator’s Guide (G251-2267-02).
  • IBM Informix Dynamic Server Administrator’s Reference (G251-2268-01).

Trademarks & Liability

  • This article describes the operations done on a test system, in no case the author(s) should be liable to potential errors or malfunction one could encounter while applying what is described herein.
  • IIUG and the IIUG logo are trademarks of the International Informix Users Group in the United States of America and other countries.
  • IBM, Informix, Client SDK, IDS, Informix, DB-Access are trademarks of International Business Machines Corporation in the United States of America and other countries.
  • Java and all Java-based trademarks are trademarks of Sun Microsystems, Inc. in the United States of America and other countries.
  • UNIX is a registered trademark of The Open Group in the United States of America and other countries.
  • Linux is a trademark of Linus Torvalds in the United States of America and other countries.
  • Microsoft, Windows NT, Windows 2000, Windows XP, Windows XP Professional, Word are trademarks of Microsoft Corporation in the United States of America and other countries.
  • Other brand and product names are trademarks or registered trademarks of their respective holders.