HPL problem

Hoping you can help.... I am running IDS 7.23 on a SCOUnix platform. I have an onpload job that unloads the complete contents of a table and sends the contents to a pipe. The onpload script is launched remotely using Rexec. My problem lies in that if the front end dies (for whatever reason) the onpload terminates and writes the correct error to the error log but I cannot launch another onpload script without rebooting the box. When I launch a subsequent script it tells me there's a problem initialising MT shared memory? Any help is appreciated.... Andy

When onpload terminates have you tried killing the master onpload (ps -ef|grep onpload) thread before trying to relaunch? -----Original Message----- From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On Behalf Of ANDY MCCOLL Sent: Tuesday, April 26, 2005 8:04 AM To: ids@iiug.org Subject: HPL problem [4809] Hoping you can help.... I am running IDS 7.23 on a SCOUnix platform. I have an onpload job that unloads the complete contents of a table and sends the contents to a pipe. The onpload script is launched remotely using Rexec. My problem lies in that if the front end dies (for whatever reason) the onpload terminates and writes the correct error to the error log but I cannot launch another onpload script without rebooting the box. When I launch a subsequent script it tells me there's a problem initialising MT shared memory? Any help is appreciated.... Andy

--0__=08BBE57CDFF462AB8f9e8a93df938690918c08BBE57CDFF462AB Content-type: multipart/alternative; Boundary="1__=08BBE57CDFF462AB8f9e8a93df938690918c08BBE57CDFF462AB" --1__=08BBE57CDFF462AB8f9e8a93df938690918c08BBE57CDFF462AB Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: quoted-printable Hi Andy, I think the version of the server is quite old. But I think you can do the following:- ps -aef | grep pload and kill all the pload processes before restarting= the job. It should not require reboot. Also check in the onstat -g seg/root ipcs if any new segmentsshared mem= ory were allocated and not released. Regards, Pravin. = "ANDY MCCOLL" = <andy.mccoll@vern = ons.co.uk> = To Sent by: ids@iiug.org = forum.subscriber@ = cc iiug.org = Subj= ect HPL problem [4809] = 04/26/2005 08:03 = AM = = = = = Hoping you can help.... I am running IDS 7.23 on a SCOUnix platform. I have an onpload job that= unloads the complete contents of a table and sends the contents to a pi= pe. The onpload script is launched remotely using Rexec. My problem lies in that if the front end dies (for whatever reason) the= onpload terminates and writes the correct error to the error log but I cannot launch another onpload script without rebooting the box. When I launch a subsequent script it tells me there's a problem initialising MT shared memory? Any help is appreciated.... Andy = --1__=08BBE57CDFF462AB8f9e8a93df938690918c08BBE57CDFF462AB Content-type: text/html; charset=US-ASCII Content-Disposition: inline Content-transfer-encoding: quoted-printable <html><body> <p>Hi Andy,<br> <br> I think the version of the server is quite old.<br> But I think you can do the following:-<br> <br> ps -aef | grep pload and kill all the pload processes before restarting= the job. It should not require reboot.<br> <br> Also check in the onstat -g seg/root ipcs if any new segmentsshared mem= ory were allocated and not released.<br> <br> Regards,<br> Pravin.<br> <img src=3D"cid:10__=3D08BBE57CDFF462AB8f9e8a93df938@us.ibm.com" width=3D= "16" height=3D"16" alt=3D"Inactive hide details for &quot;ANDY MCCOLL&q= uot; &lt;andy.mccoll@vernons.co.uk&gt;">&quot;ANDY MCCOLL&quot; &lt;and= y.mccoll@vernons.co.uk&gt;<br> <br> <br> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D08BBE57= CDFF462AB8f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid= th=3D"40%"> <ul> <ul> <ul> <ul><b><font size=3D"2">&quot;ANDY MCCOLL&quot; &lt;andy.mccoll@vernons= .co.uk&gt;</font></b><font size=3D"2"> </font><br> <font size=3D"2">Sent by: forum.subscriber@iiug.org</font> <p><font size=3D"2">04/26/2005 08:03 AM</font></ul> </ul> </ul> </ul> </td><td width=3D"60%"> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D08BBE57CDFF462AB8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">To</font></div></td><td width=3D"= 100%"><img src=3D"cid:30__=3D08BBE57CDFF462AB8f9e8a93df938@us.ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> <font size=3D"2">ids@iiug.org</font></td></tr> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D08BBE57CDFF462AB8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">cc</font></div></td><td width=3D"= 100%"><img src=3D"cid:30__=3D08BBE57CDFF462AB8f9e8a93df938@us.ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> </td></tr> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D08BBE57CDFF462AB8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">Subject</font></div></td><td widt= h=3D"100%"><img src=3D"cid:30__=3D08BBE57CDFF462AB8f9e8a93df938@us.ibm.= com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> <font size=3D"2">HPL problem [4809]</font></td></tr> </table> <table border=3D"0" cellspacing=3D"0" cellpadding=3D"0"> <tr valign=3D"top"><td width=3D"58"><img src=3D"cid:30__=3D08BBE57CDFF4= 62AB8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt= =3D""></td><td width=3D"336"><img src=3D"cid:30__=3D08BBE57CDFF462AB8f9= e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><= /td></tr> </table> </td></tr> </table> <br> <tt>Hoping you can help....<br> <br> I am running IDS 7.23 on a SCOUnix platform. I have an onpload job that= unloads the complete contents of a table and sends the contents to a p= ipe. The onpload script is launched remotely using Rexec. <br> <br> My problem lies in that if the front end dies (for whatever reason) the= onpload terminates and writes the correct error to the error log but I= cannot launch another onpload script without rebooting the box.<br> <br> When I launch a subsequent script it tells me there's a problem initial= ising MT shared memory?<br> <br> Any help is appreciated....<br> <br> Andy<br> <br> </tt><br> </body></html>= --1__=08BBE57CDFF462AB8f9e8a93df938690918c08BBE57CDFF462AB-- --0__=08BBE57CDFF462AB8f9e8a93df938690918c08BBE57CDFF462AB Content-type: image/gif; name="graycol.gif" Content-Disposition: inline; filename="graycol.gif" Content-ID: <10__=08BBE57CDFF462AB8f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhEAAQAKECAMzMzAAAAP///wAAACH5BAEAAAIALAAAAAAQABAAAAIXlI+py+0PopwxUbpu ZRfKZ2zgSJbmSRYAIf4fT3B0aW1pemVkIGJ5IFVsZWFkIFNtYXJ0U2F2ZXIhAAA7 --0__=08BBE57CDFF462AB8f9e8a93df938690918c08BBE57CDFF462AB Content-type: image/gif; name="pic07941.gif" Content-Disposition: inline; filename="pic07941.gif" Content-ID: <20__=08BBE57CDFF462AB8f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhWABDALP/AAAAAK04Qf79/o+Gm7WuwlNObwoJFCsoSMDAwGFsmIuezf///wAAAAAAAAAA AAAAACH5BAEAAAgALAAAAABYAEMAQAT/EMlJq704682770RiFMRinqggEUNSHIchG0BCfHhOjAuh

Hi, I neither have the version nor the platform to test this. But what happens most likely is something like this: HPL uses it's own shared memory (i.e. shared memory that is allocated by HPL independently from IDS server's shared memory). For some reason, something of this shared memory is leftover after HPL (the onpload processes) have terminated. You should be able to see this leftover SHM from HPL using a system command like "ipcs -m", but do not confuse the IDS server's SHM segments with those of HPL . You would then have to remove those left-over HPL SHM segments (using a command like "ipcrm -m <shmid>"). After that you should be able to start HPL again, without rebooting the machine. (It may be a problem of HPL that this SHM is not removed properly, even though HPL is actively exiting, even writing an error message to that effect. However, 7.23 is a rather old version and there's no hope to get this fixed there. So the above procedure is probably the workaround you have to adopt for this situation ...) Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management forum.subscriber@iiug.org wrote on 26.04.2005 15:03:57: > Hoping you can help.... > > I am running IDS 7.23 on a SCOUnix platform. I have an onpload job that unloads > the complete contents of a table and sends the contents to a pipe. The onpload> script is launched remotely using Rexec. > > My problem lies in that if the front end dies (for whatever reason) the onpload> terminates and writes the correct error to the error log but I cannot launch > another onpload script without rebooting the box. > > When I launch a subsequent script it tells me there's a problem initialising MT shared memory? > > Any help is appreciated.... > > Andy