Receiving Bad file number

IDS: 11.50.FC5 OS: SunOS 5.10 Could this be a bad network card? SQL: New Run Modify Use-editor Output Choose Save Info Drop Exit Modify the current SQL statements using the SQL editor. ---------- subsidyreporting@ifmx00307 ---------- Press CTRL-W for Help -------- select * from ips_extract_number 25582: Network connection is broken.Bad file number Thanks, ******************************************************************************** ********** Ernie Knox Sr. Technical Specialist, I&TG - IT Operations & Governance Sears Holdings Management Corp 3333 Beverly Rd. Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com<mailto:Ernest.Knox@searshc.com> Blackberry: 2244650553@messaging.sprintpcs.com<mailto:2244650553@messaging.sprintpcs.com> Informix Email: ifmxdba@searshc.com<mailto:ifmxdba@searshc.com> and Team: InformixDBA@searshc.com<mailto:InformixDBA@searshc.com> Informix Primary: INFORMIXDBAPrimaryPager@searshc.com<mailto:INFORMIXDBAPrimaryPager@searshc.com> Informix Secondary: INFORMIXDBASecondaryPager@searshc.com<mailto:INFORMIXDBASecondaryPager@searshc.c om> MySQL Email: MYSQLDBAe@searshc.com<mailto:MYSQLDBAe@searshc.com> and Team: MySQLDBA2@searshc.com<mailto:MySQLDBA2@searshc.com> MySQL Primary: MYSQLDBAPrimaryPager@searshc.com<mailto:MYSQLDBAPrimaryPager@searshc.com> MySQL Secondary: MYSQLDBASecondaryPager@searshc.com<mailto:MYSQLDBASecondaryPager@searshc.com> For more information, view our DBA Wiki page link below: http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Management#Dat abaseManagement<http://wiki.intra.sears.com/confluence/display/TechStrag/Databas e+Management> " Yes we can make a Change! " " IF you can think it, you can do it! " " IT'S always a great day to watch Sports: FOOTBALL " GSU MISSION: " The focus of my life begins at home with family, loved ones, and friends. I want to use my resources to create a secure environment that fosters love, learning, laughter, and mutual success. I will protect and value integrity. I will admit and quickly correct my mistakes. I will be a self-starter. I will be a caring person. I will be a good listener with an open mind. I will continue to grow and learn. I will facilitate and celebrate the success of others. " ******************************************************************************** ********** This message, including any attachments, is the property of Sears Holdings Corporation and/or one of its subsidiaries. It is confidential and may contain proprietary or legally privileged information. If you are not the intended recipient, please delete it without reading the contents. Thank you.

If it is then will be something in the message log Cheers Paul Paul Watson +1 913-387-7529 www.oninit.com On May 6, 2013, at 2:49, "Knox, Ernest" <Ernest.Knox@searshc.com> wrote: > IDS: 11.50.FC5=20 > OS: SunOS 5.10=20 >=20 > Could this be a bad network card?=20 >=20 > SQL: New Run Modify Use-editor Output Choose Save Info Drop Exit=20 > Modify the current SQL statements using the SQL editor.=20 >=20 > ---------- subsidyreporting@ifmx00307 ---------- Press CTRL-W for Help=20 > --------=20 >=20 > select * from ips_extract_number=20>=20 > 25582: Network connection is broken.=20> Bad file number=20 >=20 > Thanks,=20 >=20 > **************************************************************************= ****************=20 > Ernie Knox=20 > Sr. Technical Specialist, I&TG - IT Operations & Governance=20 > Sears Holdings Management Corp=20 > 3333 Beverly Rd.=20 > Hoffman Estates, IL. 60179=20 > Office: (847) 286-5735=20 > Email: Ernest.Knox@searshc.com<mailto:Ernest.Knox@searshc.com>=20 > Blackberry:=20 > 2244650553@messaging.sprintpcs.com<mailto:2244650553@messaging.sprintpcs.c= om>=20 > Informix Email: ifmxdba@searshc.com<mailto:ifmxdba@searshc.com> and Team:=20= > InformixDBA@searshc.com<mailto:InformixDBA@searshc.com>=20 > Informix Primary:=20 > INFORMIXDBAPrimaryPager@searshc.com<mailto:INFORMIXDBAPrimaryPager@searshc= .com>=20 > Informix Secondary:=20 > INFORMIXDBASecondaryPager@searshc.com<mailto:INFORMIXDBASecondaryPager@sea= rshc.com>=20 > MySQL Email: MYSQLDBAe@searshc.com<mailto:MYSQLDBAe@searshc.com> and Team:= =20 > MySQLDBA2@searshc.com<mailto:MySQLDBA2@searshc.com>=20 > MySQL Primary:=20 > MYSQLDBAPrimaryPager@searshc.com<mailto:MYSQLDBAPrimaryPager@searshc.com>=20= > MySQL Secondary:=20 > MYSQLDBASecondaryPager@searshc.com<mailto:MYSQLDBASecondaryPager@searshc.c= om>=20 >=20 > For more information, view our DBA Wiki page link below:=20 >=20 > http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Manageme= nt#DatabaseManagement<http://wiki.intra.sears.com/confluence/display/TechStr= ag/Database+Management>=20 >=20 > " Yes we can make a Change! "=20 > " IF you can think it, you can do it! "=20 > " IT'S always a great day to watch Sports: FOOTBALL "=20 > GSU=20 > MISSION:=20 > " The focus of my life begins at home with family, loved ones, and friends= . I=20 > want to use my resources to create a=20 > secure environment that fosters love, learning, laughter, and mutual succe= ss.=20 > I will protect and value integrity. I=20 > will admit and quickly correct my mistakes. I will be a self-starter. I wi= ll=20 > be a caring person. I will be a good listener=20 > with an open mind. I will continue to grow and learn. I will facilitate an= d=20 > celebrate the success of others. "=20 >=20 > **************************************************************************= ****************=20 >=20 > This message, including any attachments, is the property of Sears Holdings= =20 > Corporation and/or one of its subsidiaries. It is confidential and may con= tain=20 > proprietary or legally privileged information. If you are not the intended= =20 > recipient, please delete it without reading the contents. Thank you.=20 >=20 >=20 > **************************************************************************= *****=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20

It seems you are hitting some OS limits. Check your machine notes for OS patch levels, OS prereqs (kernel parameters), if you are fine according to recommendations, ask us for any additional help. Remember that 11.50 is an old version, you should always consider upgrading options, to get the latest features, and better performance. Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional Informix Senior DBA - Orizon Brasil BRIUG website administrator Informix independent consultant > To: ids@iiug.org > From: Ernest.Knox@searshc.com > Subject: Receiving Bad file number [30196] > Date: Mon, 6 May 2013 03:49:54 -0400 > > IDS: 11.50.FC5 > OS: SunOS 5.10 > > Could this be a bad network card? > > SQL: New Run Modify Use-editor Output Choose Save Info Drop Exit > Modify the current SQL statements using the SQL editor. > > ---------- subsidyreporting@ifmx00307 ---------- Press CTRL-W for Help > -------- > > select * from ips_extract_number> > 25582: Network connection is broken.> Bad file number > > Thanks, > > ******************************************************************************** ********** > Ernie Knox > Sr. Technical Specialist, I&TG - IT Operations & Governance > Sears Holdings Management Corp > 3333 Beverly Rd. > Hoffman Estates, IL. 60179 > Office: (847) 286-5735 > Email: Ernest.Knox@searshc.com<mailto:Ernest.Knox@searshc.com> > Blackberry: > 2244650553@messaging.sprintpcs.com<mailto:2244650553@messaging.sprintpcs.com> > Informix Email: ifmxdba@searshc.com<mailto:ifmxdba@searshc.com> and Team: > InformixDBA@searshc.com<mailto:InformixDBA@searshc.com> > Informix Primary: > INFORMIXDBAPrimaryPager@searshc.com<mailto:INFORMIXDBAPrimaryPager@searshc.com> > Informix Secondary: > INFORMIXDBASecondaryPager@searshc.com<mailto:INFORMIXDBASecondaryPager@searshc.c om> > MySQL Email: MYSQLDBAe@searshc.com<mailto:MYSQLDBAe@searshc.com> and Team: > MySQLDBA2@searshc.com<mailto:MySQLDBA2@searshc.com> > MySQL Primary: > MYSQLDBAPrimaryPager@searshc.com<mailto:MYSQLDBAPrimaryPager@searshc.com> > MySQL Secondary: > MYSQLDBASecondaryPager@searshc.com<mailto:MYSQLDBASecondaryPager@searshc.com> > > For more information, view our DBA Wiki page link below: > > http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Management#Dat abaseManagement<http://wiki.intra.sears.com/confluence/display/TechStrag/Databas e+Management> > > " Yes we can make a Change! " > " IF you can think it, you can do it! " > " IT'S always a great day to watch Sports: FOOTBALL " > GSU > MISSION: > " The focus of my life begins at home with family, loved ones, and friends. I > want to use my resources to create a > secure environment that fosters love, learning, laughter, and mutual success. > I will protect and value integrity. I > will admit and quickly correct my mistakes. I will be a self-starter. I will > be a caring person. I will be a good listener > with an open mind. I will continue to grow and learn. I will facilitate and > celebrate the success of others. " > > ******************************************************************************** ********** > > This message, including any attachments, is the property of Sears Holdings > Corporation and/or one of its subsidiaries. It is confidential and may contain > proprietary or legally privileged information. If you are not the intended > recipient, please delete it without reading the contents. Thank you. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >