RE: Question Concerning HPL Error.

Posted in 2008

Knox, Ernest — Tue, 04 Nov 2008 05:27:07 — source: IIUG Forums & Mailing Lists

My customer is receiving the following errors when she performs an HPL load process: "I got this message during load of the new table. 22:13:09 dynamically allocated new shared memory segment (size 4194304) 2: 2: cannot open 22:13:16 dynamically allocated new shared memory segment (size 4194304) 22:13:31 pl_main.c, line 546, thread 6, proc id 16715, Segmentation Violation. 2: 2: cannot open 22:13:31 pl_main.c, line 546, thread 6, proc id 16715, Segmentation Violation. 22:13:31 PANIC: Attempting to bring system down vriload_recon_aggr.sh[4]: 16709 Killed" This is on: Sun Microsystems Inc. SunOS 5.6 Informix Dynamic Server Version 7.30.UC3 The load file contains 96410 rows, 68000 rows were good and 28410 rows were errors. Thanks, *************************************** Ernie Knox Sears Holding Co. IT Database Administrator Specialist 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: eknox@searshc.com <mailto:eknox@searshc.com> Blackberry: 2244650553@messaging.sprintpcs.com Page via Skytel: 2244650553@sprint.skytel.com " It's always a great day to watch Football - GO LIONS, TIGERS and BEARS! " *************************************** -----Original Message----- From: Knox, Ernest Sent: Monday, November 03, 2008 11:07 PM To: 'ids@iiug.org' Subject: Question Concerning DBLOAD Syntax Error. I am trying to load a file with error rows using DBLOAD. I test it on AIX 4.3.3.0 and IDS 7.31 and it works fine. I'm receiving a syntax error when I try to run it on SUN 5.6 and IDS 7.30. Any idea or manual doc differences between the two versions? 307a :/sidcbackup/ernie_knox>ls -l total 46112 -rw-r--r-- 1 informix informix 7880729 Nov 3 17:06 aggr_period_full.unl rw-r--r-- 1 informix informix 73 Nov 3 22:41 recon_aggr_dtl.cmd -rw-r--r-- 1 informix informix 275 Nov 3 22:08 recon_aggr_dtl.out AIX 4.3.3.0 Informix Dynamic Server Version 7.31.UC5 Runs fine with no syntax errors. Sun Microsystems Inc. SunOS 5.6 Informix Dynamic Server Version 7.30.UC3 307a :/sidcbackup/ernie_knox>cat recon_aggr_dtl.out DBLOAD Load Utility INFORMIX-SQL Version 7.30.UC3 Copyright (C) Informix Software, Inc., 1984-1998 Software Serial Number ACN#J284372 FILE /sidcbackup/ernie_knox/aggr_period_full.unl DELIMITER '|' 16; Syntax error occurs on statement above. Line 1 Character 6 Thanks, *************************************** Ernie Knox Sears Holding Co. IT Database Administrator Specialist 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: eknox@searshc.com <mailto:eknox@searshc.com> Blackberry: 2244650553@messaging.sprintpcs.com Page via Skytel: 2244650553@sprint.skytel.com " It's always a great day to watch Football - GO LIONS, TIGERS and BEARS! " ***************************************