Re: Error building 'sysmaster' database

Posted in 2013

Summary

A user initializing a new instance saw buildsmi fail with errors like "9628: Type (bigint) not found" and missing sysptnhdr, so sysmaster wouldn't build. From the posted online.log, Marcus Haarmann spotted that the engine actually booting was IDS 10.00.UC9, while the buildsmi script came from the newer 11.50 install (bigint only exists from 11.50) — i.e. two installations (/usr/informix and /usr/informix1) were being mixed. Advice was to use a clean install/correct INFORMIXDIR, and Justin Killen suggested invoking the binaries by full path (/usr/informix1/bin/oninit) rather than relying on PATH, which picked the old 10.00 oninit. No confirmation from the poster that this fixed it is recorded.

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: Connectivity: ESQL/C, 4GL & Embedded SQL, Server Administration, Networking & sqlhosts Configuration

HOAN LUU VAN — Thu, 12 Sep 2013 07:12:31 — source: IIUG Forums & Mailing Lists

Yes, I already set necessary environment variables and source them before I run oninit command. setenv INFORMIXDIR /usr/informix1 setenv INFORMIXSERVER lvhoan setenv ONCONFIG onconfig_lvhoan setenv INFORMIXSQLHOSTS ${INFORMIXDIR}/etc/sqlhosts_lvhoansetenv LD_LIBRARY_PATH ${LD_LIBRARY_PATH}:${INFORMIXDIR}/lib:${INFORMIXDIR}/lib/esql setenv PATH ${PATH}:${INFORMIXDIR}/binsetenv LVHOAN /usr/informix1/instances/${INFORMIXSERVER}

↪ replying to HOAN LUU VAN

Marcus Haarmann — Thu, 12 Sep 2013 07:23:01 — source: IIUG Forums & Mailing Lists

Hi, since we do not have the output of your buildsmi command, due to no attachments supported in the list, we cannot help. Please post at least some lines in mail text. Best regards, Marcus Haarmann ----- Ursprüngliche Mail ----- Von: "HOAN LUU VAN" <hoan.luuvan@nttdata.com> An: ids@iiug.org Gesendet: Donnerstag, 12. September 2013 09:12:32 Betreff: Re: Error building 'sysmaster' database [31398] Yes, I already set necessary environment variables and source them before I run oninit command. setenv INFORMIXDIR /usr/informix1 setenv INFORMIXSERVER lvhoan setenv ONCONFIG onconfig_lvhoan setenv INFORMIXSQLHOSTS ${INFORMIXDIR}/etc/sqlhosts_lvhoansetenv LD_LIBRARY_PATH ${LD_LIBRARY_PATH}:${INFORMIXDIR}/lib:${INFORMIXDIR}/lib/esql setenv PATH ${PATH}:${INFORMIXDIR}/binsetenv LVHOAN /usr/informix1/instances/${INFORMIXSERVER} ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Marcus Haarmann

HOAN LUU VAN — Thu, 12 Sep 2013 07:53:14 — source: IIUG Forums & Mailing Lists

Many thanks for your prompt response. I uploaded all logs and config files to my mediafire. Please go to the link below to get them. http://alu5.yfzzqye5can.qjtv.e.s48.wbprx.com/download/vz0lv5yrq0cs9k9/Error_buil ding_sysmaster_db.rar Looking forward to your help.

↪ replying to HOAN LUU VAN

Marcus Haarmann — Thu, 12 Sep 2013 08:21:34 — source: IIUG Forums & Mailing Lists

Sorry, download not possible. Please post the error lines in clear text. Marcus Haarmann ----- Ursprüngliche Mail ----- Von: "HOAN LUU VAN" <hoan.luuvan@nttdata.com> An: ids@iiug.org Gesendet: Donnerstag, 12. September 2013 09:53:15 Betreff: Re: Error building 'sysmaster' database [31400] Many thanks for your prompt response. I uploaded all logs and config files to my mediafire. Please go to the link below to get them. http://alu5.yfzzqye5can.qjtv.e.s48.wbprx.com/download/vz0lv5yrq0cs9k9/Error_buil ding_sysmaster_db.rar Looking forward to your help. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to HOAN LUU VAN

Marcus Haarmann — Thu, 12 Sep 2013 08:45:12 — source: IIUG Forums & Mailing Lists

Hi Hoan, it seems you are initializing a 10.x IDS with a buildsmi script from a 11.50+ which includes the usage of new datatypes (bigint). 14:39:59 IBM Informix Dynamic Server Version 10.00.UC9 Software Serial Number AAA#B000000 Excerpt from buildsmi output: 9628: Type (bigint) not found. Error in line 181Near character position 0 206: The specified table (sysptnhdr) is not in the database. 111: ISAM error: no record found. Error in line 182Near character position 51 206: The specified table (sysptnhdr) is not in the database. 111: ISAM error: no record found. Error in line 183Near character position 29 206: The specified table (sysptnhdr) is not in the database. 111: ISAM error: no record found. Error in line 184Near character position 31 I would assume, you have mixed installations in one dir. Please re-install the 10.00 release in a clean location and you should be able to work. Not to mention, 10.00 is way out of support. It seems you have a 11.50+ release somewhere, because the bigint datatype was introduced in 11.50 ( http://pic.dhe.ibm.com/infocenter/idshelp/v115/index.jsp?topic=%2Fcom.ibm.sqls.d oc%2Fids_sqs_0203.htm ) Hope this helps, Marcus Haarmann ----- Ursprüngliche Mail ----- Von: "HOAN LUU VAN" <hoan.luuvan@nttdata.com> An: ids@iiug.org Gesendet: Donnerstag, 12. September 2013 09:53:15 Betreff: Re: Error building 'sysmaster' database [31400] Many thanks for your prompt response. I uploaded all logs and config files to my mediafire. Please go to the link below to get them. http://alu5.yfzzqye5can.qjtv.e.s48.wbprx.com/download/vz0lv5yrq0cs9k9/Error_buil ding_sysmaster_db.rar Looking forward to your help. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Marcus Haarmann

HOAN LUU VAN — Thu, 12 Sep 2013 09:58:45 — source: IIUG Forums & Mailing Lists

My server has already informix 10 instaled before in /usr/informix. And then I installed informix 11.5 in a different folder /usr/informix1. Afer oninit finished, here is output of onstat command: M4K2-SysAdmDev2:informix > onstat - IBM Informix Dynamic Server Version 11.50.FC9DE -- On-Line -- Up 00:00:47 --38912 Kbytes M4K2-SysAdmDev2:informix >

↪ replying to HOAN LUU VAN

Marcus Haarmann — Thu, 12 Sep 2013 10:38:58 — source: IIUG Forums & Mailing Lists

Your online.log says you are startion version 10.00 14:39:54 IBM Informix Dynamic Server Started. Thu Sep 12 14:39:54 2013 14:39:54 Warning: ONCONFIG dump directory (DUMPDIR) '/usr/informix1/instances/lvhoan/logs' has insecure permissions 14:39:54 Event alarms enabled. ALARMPROG = '/usr/informix1/etc/alarmprogram.sh' 14:39:54 Booting Language <c> from module <> 14:39:54 Loading Module <CNULL> 14:39:54 Booting Language <builtin> from module <> 14:39:54 Loading Module <BUILTINNULL> 14:39:54 Dynamically allocated new virtual shared memory segment (size 8192KB) 14:39:54 Memory sizes:resident:12288 KB, virtual:16384 KB, no SHMTOTAL limit 14:39:59 DR: DRAUTO is 0 (Off) 14:39:59 IBM Informix Dynamic Server Version 10.00.UC9 Software Serial Number AAA#B000000 14:40:07 IBM Informix Dynamic Server Initialized -- Complete Disk Initialized. 14:40:08 Checkpoint Completed: duration was 0 seconds. 14:40:08 Checkpoint loguniq 1, logpos 0xd0, timestamp: 0x51 Marcus Haarmann ----- Ursprüngliche Mail ----- Von: "HOAN LUU VAN" <hoan.luuvan@nttdata.com> An: ids@iiug.org Gesendet: Donnerstag, 12. September 2013 11:58:46 Betreff: Re: Error building 'sysmaster' database [31403] My server has already informix 10 instaled before in /usr/informix. And then I installed informix 11.5 in a different folder /usr/informix1. Afer oninit finished, here is output of onstat command: M4K2-SysAdmDev2:informix > onstat - IBM Informix Dynamic Server Version 11.50.FC9DE -- On-Line -- Up 00:00:47 --38912 Kbytes M4K2-SysAdmDev2:informix > ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Marcus Haarmann

Justin Killen — Fri, 13 Sep 2013 18:45:24 — source: IIUG Forums & Mailing Lists

Seems to me like you should reference all commands using the full path instead of relying on the PATH variable to be choosing the correct one. Try /usr/informix1/oninit instead of oninit -Justin -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Marcus Haarmann Sent: Thursday, September 12, 2013 3:39 AM To: ids@iiug.org Subject: Re: Error building 'sysmaster' database [31404] Your online.log says you are startion version 10.00 14:39:54 IBM Informix Dynamic Server Started. Thu Sep 12 14:39:54 2013 14:39:54 Warning: ONCONFIG dump directory (DUMPDIR) '/usr/informix1/instances/lvhoan/logs' has insecure permissions 14:39:54 Event alarms enabled. ALARMPROG = '/usr/informix1/etc/alarmprogram.sh' 14:39:54 Booting Language <c> from module <> 14:39:54 Loading Module <CNULL> 14:39:54 Booting Language <builtin> from module <> 14:39:54 Loading Module <BUILTINNULL> 14:39:54 Dynamically allocated new virtual shared memory segment (size 8192KB) 14:39:54 Memory sizes:resident:12288 KB, virtual:16384 KB, no SHMTOTAL limit 14:39:59 DR: DRAUTO is 0 (Off) 14:39:59 IBM Informix Dynamic Server Version 10.00.UC9 Software Serial Number AAA#B000000 14:40:07 IBM Informix Dynamic Server Initialized -- Complete Disk Initialized. 14:40:08 Checkpoint Completed: duration was 0 seconds. 14:40:08 Checkpoint loguniq 1, logpos 0xd0, timestamp: 0x51 Marcus Haarmann ----- Ursprüngliche Mail ----- Von: "HOAN LUU VAN" <hoan.luuvan@nttdata.com> An: ids@iiug.org Gesendet: Donnerstag, 12. September 2013 11:58:46 Betreff: Re: Error building 'sysmaster' database [31403] My server has already informix 10 instaled before in /usr/informix. And then I installed informix 11.5 in a different folder /usr/informix1. Afer oninit finished, here is output of onstat command: M4K2-SysAdmDev2:informix > onstat - IBM Informix Dynamic Server Version 11.50.FC9DE -- On-Line -- Up 00:00:47 --38912 Kbytes M4K2-SysAdmDev2:informix > ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Re: Error building 'sysmaster' database

Glossary

Your privacy choices