Oninit cdi / Archive
Talk to an expert →

Instance will not come up.

Posted in 2012

Topics: Stored Procedures & SPL, Error Codes & Troubleshooting, Server Administration, Platform-Specific Issues

Knox, Ernest — — source: IIUG Forums & Mailing Lists

IDS: 10.00.UC5 OS: AIX 5.3.0.0 The instance will not come back up. Is a restore from backup the only option? informix@sls0446 [/usr/informix]: $onstat -m IBM Informix Dynamic Server Version 10.00.UC5 -- Fast Recovery -- Up 00:00:44 -- 621984 Kbytes Message Log File: /ifmx/ifmx04461/fs_server/online.log 02:37:42 ptmap 02:37:42 Assert Failed: ptmap02:37:42 IBM Informix Dynamic Server Version 10.00.UC5 02:37:42 Who: Session(12, informix@sls0446, 0, 50228e50) Thread(24, xchg_1.0, 50202290, 1) File: rspartn.c Line: 2426 02:37:42 Results: Could not complete operation on 'ltw:"dbaltw".prorep_punch' 02:37:42 Action: Run 'oncheck -cDI ltw:"dbaltw".prorep_punch' 02:37:42 stack trace for pid 41548 written to /tmp/af.400f4ac 02:37:42 See Also: /tmp/af.400f4ac 02:37:46 ptmap 02:37:47 Assert Failed: ptmap 02:37:47 IBM Informix Dynamic Server Version 10.00.UC5 02:37:47 Who: Session(12, informix@sls0446, 0, 50228e50) Thread(24, xchg_1.0, 50202290, 1) File: rspartn.c Line: 2426 02:37:47 Results: Could not complete operation on 'ltw:"dbaltw".prorep_punch' 02:37:47 Action: Run 'oncheck -cDI ltw:"dbaltw".prorep_punch' 02:37:47 stack trace for pid 41548 written to /tmp/af.400f4ac 02:37:47 See Also: /tmp/af.400f4ac Thanks, ******************************************************************* Ernie Knox IT Database Administrator Specialist Sears Holdings - BU: I & T Group 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, use 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! " " It's always a great day to watch Sports: " GSU ******************************************************************* 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.

↪ replying to Knox, Ernest
Knox, Ernest — — source: IIUG Forums & Mailing Lists

Thanks, ******************************************************************* Ernie Knox IT Database=A0Administrator Specialist Sears Holdings - BU: I & T Group 3333 Beverly Rd. Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry:=A02244650553@messaging.sprintpcs.com Informix Email: ifmxdba@searshc.com and Team: InformixDBA@searshc.com Informix Primary: INFORMIXDBAPrimaryPager@searshc.com Informix Secondary: INFORMIXDBASecondaryPager@searshc.com MySQL Email: MYSQLDBAe@searshc.com and Team: MySQLDBA2@searshc.com MySQL Primary: MYSQLDBAPrimaryPager@searshc.com MySQL Secondary: MYSQLDBASecondaryPager@searshc.com For more information, use our DBA Wiki page link below: http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Managemen= t#DatabaseManagement " Yes we can make a Change! " " It's always a great day to watch=A0Sports: " GSU ******************************************************************* -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Knox,= Ernest Sent: Friday, August 17, 2012 3:48 AM To: ids@iiug.org Subject: Instance will not come up. [28063] IDS: 10.00.UC5 OS: AIX 5.3.0.0=20 The instance will not come back up. Is a restore from backup the only optio= n?=20 informix@sls0446 [/usr/informix]:=20 $onstat -m=20 IBM Informix Dynamic Server Version 10.00.UC5 -- Fast Recovery -- Up 00:00:=44 -- 621984 Kbytes=20 Message Log File: /ifmx/ifmx04461/fs_server/online.log 02:37:42 ptmap 02:37:42 Assert Failed: ptmap 02:37:42 IBM Informix Dynamic Server Version 10.00.UC5 02:37:42 Who: Session(12, informix@sls0446, 0, 50228e50)=20 Thread(24, xchg_1.0, 50202290, 1)=20 File: rspartn.c Line: 2426 02:37:42 Results: Could not complete operation on 'ltw:"dbaltw".prorep_punc= h'=20 02:37:42 Action: Run 'oncheck -cDI ltw:"dbaltw".prorep_punch'=20 02:37:42 stack trace for pid 41548 written to /tmp/af.400f4ac 02:37:42 See Also: /tmp/af.400f4ac 02:37:46 ptmap 02:37:47 Assert Failed: ptmap 02:37:47 IBM Informix Dynamic Server Version 10.00.UC5 02:37:47 Who: Session(12, informix@sls0446, 0, 50228e50)=20 Thread(24, xchg_1.0, 50202290, 1)=20 File: rspartn.c Line: 2426 02:37:47 Results: Could not complete operation on 'ltw:"dbaltw".prorep_punc= h'=20 02:37:47 Action: Run 'oncheck -cDI ltw:"dbaltw".prorep_punch'=20 02:37:47 stack trace for pid 41548 written to /tmp/af.400f4ac 02:37:47 See Also: /tmp/af.400f4ac=20 Thanks, ******************************************************************* Ernie Knox IT Database Administrator Specialist Sears Holdings - BU: I & T Group 3333 Beverly Rd.=20 Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com<mailto:Ernest.Knox@searshc.com> Blackberry:=20 2244650553@messaging.sprintpcs.com<mailto:2244650553@messaging.sprintpcs.co= m> Informix Email: ifmxdba@searshc.com<mailto:ifmxdba@searshc.com> and Team:= =20 InformixDBA@searshc.com<mailto:InformixDBA@searshc.com> Informix Primary:=20 INFORMIXDBAPrimaryPager@searshc.com<mailto:INFORMIXDBAPrimaryPager@searshc.= com> Informix Secondary:=20 INFORMIXDBASecondaryPager@searshc.com<mailto:INFORMIXDBASecondaryPager@sear= shc.com> MySQL Email: MYSQLDBAe@searshc.com<mailto:MYSQLDBAe@searshc.com> and Team:= =20 MySQLDBA2@searshc.com<mailto:MySQLDBA2@searshc.com> MySQL Primary:=20 MYSQLDBAPrimaryPager@searshc.com<mailto:MYSQLDBAPrimaryPager@searshc.com> MySQL Secondary:=20 MYSQLDBASecondaryPager@searshc.com<mailto:MYSQLDBASecondaryPager@searshc.co= m>=20 For more information, use our DBA Wiki page link below:=20 http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Managemen= t#DatabaseManagement<http://wiki.intra.sears.com/confluence/display/TechStr= ag/Database+Management>=20 " Yes we can make a Change! "=20 " It's always a great day to watch Sports: "=20 GSU *******************************************************************=20 This message, including any attachments, is the property of Sears Holdings = Corporation and/or one of its subsidiaries. It is confidential and may cont= ain proprietary or legally privileged information. If you are not the inten= ded recipient, please delete it without reading the contents. Thank you.=20 ***************************************************************************= **** Forum Note: Use "Reply" to post a response in the discussion forum.=20 This message, including any attachments, is the property of Sears Holdings = Corporation and/or one of its subsidiaries. It is confidential and may cont= ain proprietary or legally privileged information. If you are not the inten= ded recipient, please delete it without reading the contents. Thank you.

↪ replying to Knox, Ernest
Art Kagel — — source: IIUG Forums & Mailing Lists

Have you run the recommended onchecks? That may give you more information about what happened. Bad chunk, privileges incorrect, etc. You may have to correct some problem before you can restart or if no restart is possible, to have the restore succeed. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Aug 17, 2012 at 3:48 AM, Knox, Ernest <Ernest.Knox@searshc.com>wrote: > IDS: 10.00.UC5 > OS: AIX 5.3.0.0 > > The instance will not come back up. Is a restore from backup the only > option? > > informix@sls0446 [/usr/informix]: > $onstat -m > > IBM Informix Dynamic Server Version 10.00.UC5 -- Fast Recovery -- Up > 00:00:44 > -- 621984 Kbytes > > Message Log File: /ifmx/ifmx04461/fs_server/online.log > 02:37:42 ptmap > 02:37:42 Assert Failed: ptmap> 02:37:42 IBM Informix Dynamic Server Version 10.00.UC5 > 02:37:42 Who: Session(12, informix@sls0446, 0, 50228e50) > > Thread(24, xchg_1.0, 50202290, 1) > > File: rspartn.c Line: 2426 > 02:37:42 Results: Could not complete operation on > 'ltw:"dbaltw".prorep_punch' > 02:37:42 Action: Run 'oncheck -cDI ltw:"dbaltw".prorep_punch' > 02:37:42 stack trace for pid 41548 written to /tmp/af.400f4ac > 02:37:42 See Also: /tmp/af.400f4ac > 02:37:46 ptmap > 02:37:47 Assert Failed: ptmap > 02:37:47 IBM Informix Dynamic Server Version 10.00.UC5 > 02:37:47 Who: Session(12, informix@sls0446, 0, 50228e50) > > Thread(24, xchg_1.0, 50202290, 1) > > File: rspartn.c Line: 2426 > 02:37:47 Results: Could not complete operation on > 'ltw:"dbaltw".prorep_punch' > 02:37:47 Action: Run 'oncheck -cDI ltw:"dbaltw".prorep_punch' > 02:37:47 stack trace for pid 41548 written to /tmp/af.400f4ac > 02:37:47 See Also: /tmp/af.400f4ac > > Thanks, > ******************************************************************* > Ernie Knox > IT Database Administrator Specialist > Sears Holdings - BU: I & T Group > 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.com> > 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, use 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/Database+Management > > > > " Yes we can make a Change! " > " It's always a great day to watch Sports: " > GSU > ******************************************************************* > > 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. > > --14dae93409032e6ce004c776e199

↪ replying to Art Kagel
Knox, Ernest — — source: IIUG Forums & Mailing Lists

Thanks. We ended up restoring from a backup. Since the instance would not = come on-line and allow us to run the onchecks. Thanks, ******************************************************************* Ernie Knox IT Database=A0Administrator Specialist Sears Holdings - BU: I & T Group 3333 Beverly Rd. Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry:=A02244650553@messaging.sprintpcs.com Informix Email: ifmxdba@searshc.com and Team: InformixDBA@searshc.com Informix Primary: INFORMIXDBAPrimaryPager@searshc.com Informix Secondary: INFORMIXDBASecondaryPager@searshc.com MySQL Email: MYSQLDBAe@searshc.com and Team: MySQLDBA2@searshc.com MySQL Primary: MYSQLDBAPrimaryPager@searshc.com MySQL Secondary: MYSQLDBASecondaryPager@searshc.com For more information, use our DBA Wiki page link below: http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Managemen= t#DatabaseManagement " Yes we can make a Change! " " It's always a great day to watch=A0Sports: " GSU ******************************************************************* -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art K= agel Sent: Friday, August 17, 2012 10:22 AM To: ids@iiug.org Subject: Re: Instance will not come up. [28065] Have you run the recommended onchecks? That may give you more information a= bout what happened. Bad chunk, privileges incorrect, etc. You may have to c= orrect some problem before you can restart or if no restart is possible, to= have the restore succeed.=20 Art=20 Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/=20 Disclaimer: Please keep in mind that my own opinions are my own opinions an= d do not reflect on my employer, Advanced DataTools, the IIUG, nor any othe= r organization with which I am associated either explicitly, implicitly, or= by inference. Neither do those opinions reflect those of other individuals= affiliated with any entity with which I am affiliated nor those of the ent= ities themselves.=20 On Fri, Aug 17, 2012 at 3:48 AM, Knox, Ernest <Ernest.Knox@searshc.com>wrot= e:=20 > IDS: 10.00.UC5 > OS: AIX 5.3.0.0 >=20 > The instance will not come back up. Is a restore from backup the only=20 > option? >=20 > informix@sls0446 [/usr/informix]:=20 > $onstat -m >=20 > IBM Informix Dynamic Server Version 10.00.UC5 -- Fast Recovery -- Up > 00:00:44 > -- 621984 Kbytes >=20 > Message Log File: /ifmx/ifmx04461/fs_server/online.log > 02:37:42 ptmap > 02:37:42 Assert Failed: ptmap> 02:37:42 IBM Informix Dynamic Server Version 10.00.UC5 > 02:37:42 Who: Session(12, informix@sls0446, 0, 50228e50) >=20 > Thread(24, xchg_1.0, 50202290, 1) >=20 > File: rspartn.c Line: 2426 > 02:37:42 Results: Could not complete operation on=20 > 'ltw:"dbaltw".prorep_punch' > 02:37:42 Action: Run 'oncheck -cDI ltw:"dbaltw".prorep_punch'=20 > 02:37:42 stack trace for pid 41548 written to /tmp/af.400f4ac > 02:37:42 See Also: /tmp/af.400f4ac > 02:37:46 ptmap > 02:37:47 Assert Failed: ptmap > 02:37:47 IBM Informix Dynamic Server Version 10.00.UC5 > 02:37:47 Who: Session(12, informix@sls0446, 0, 50228e50) >=20 > Thread(24, xchg_1.0, 50202290, 1) >=20 > File: rspartn.c Line: 2426 > 02:37:47 Results: Could not complete operation on=20 > 'ltw:"dbaltw".prorep_punch' > 02:37:47 Action: Run 'oncheck -cDI ltw:"dbaltw".prorep_punch'=20 > 02:37:47 stack trace for pid 41548 written to /tmp/af.400f4ac > 02:37:47 See Also: /tmp/af.400f4ac >=20 > Thanks, > ******************************************************************* > Ernie Knox > IT Database Administrator Specialist > Sears Holdings - BU: I & T Group > 3333 Beverly Rd.=20 > Hoffman Estates, IL. 60179 > Office: (847) 286-5735 > Email: Ernest.Knox@searshc.com<mailto:Ernest.Knox@searshc.com> > Blackberry:=20 > 2244650553@messaging.sprintpcs.com<mailto:=20 > 2244650553@messaging.sprintpcs.com> > Informix Email: ifmxdba@searshc.com<mailto:ifmxdba@searshc.com> and Team:= =20 > InformixDBA@searshc.com<mailto:InformixDBA@searshc.com> > Informix Primary:=20 > INFORMIXDBAPrimaryPager@searshc.com<mailto:=20 > INFORMIXDBAPrimaryPager@searshc.com> > Informix Secondary:=20 > INFORMIXDBASecondaryPager@searshc.com<mailto:=20 > INFORMIXDBASecondaryPager@searshc.com> > MySQL Email: MYSQLDBAe@searshc.com<mailto:MYSQLDBAe@searshc.com> and Team= :=20 > MySQLDBA2@searshc.com<mailto:MySQLDBA2@searshc.com> > MySQL Primary:=20 > MYSQLDBAPrimaryPager@searshc.com<mailto:MYSQLDBAPrimaryPager@searshc.c > om> > MySQL Secondary:=20 > MYSQLDBASecondaryPager@searshc.com<mailto:=20 > MYSQLDBASecondaryPager@searshc.com> >=20 > For more information, use our DBA Wiki page link below:=20 >=20 >=20 >=20 http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Managemen= t#DatabaseManagement=20 > < > http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Mana > gement > >=20 >=20 > " Yes we can make a Change! "=20 > " It's always a great day to watch Sports: "=20 > GSU > ******************************************************************* >=20 > This message, including any attachments, is the property of Sears=20 > Holdings Corporation and/or one of its subsidiaries. It is=20 > confidential and may contain proprietary or legally privileged=20 > information. If you are not the intended recipient, please delete it=20 > without reading the contents. Thank you. >=20 >=20 >=20 >=20 ***************************************************************************= ****=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20 >=20 >=20 --14dae93409032e6ce004c776e199=20 ***************************************************************************= **** Forum Note: Use "Reply" to post a response in the discussion forum.=20 This message, including any attachments, is the property of Sears Holdings = Corporation and/or one of its subsidiaries. It is confidential and may cont= ain proprietary or legally privileged information. If you are not the inten= ded recipient, please delete it without reading the contents. Thank you.

Related threads

Glossary