Databases not showing up in AUS

I recently upgrade a Windows 2003 64bit IDS 11.50 FC5 system to 11.50 FC7. After the upgrade which went without incident we no longer see all the databases in the Auto Update Statistics. We thought it was OAT so upgrade that to 2.28 from 2.26 no change. We are only seeing the sysutil, sysuser and one production database which does not give us any statistics like it use to or how the sys databases do. Have tried reseting the sysadmin no change. Have also rebuild the sysmaster with no luck. If i querry the sysmaster.sysdatabses i see all the databases and even under dbacces but for some reason they are not beign picked up by the AUS. Has anyone see this or is there something we can do to get them back??

The databases have logging? Regards. On Tue, Aug 24, 2010 at 2:42 PM, JOHN A. CHAUVIN <john.chauvin@mediware.com>wrote: > I recently upgrade a Windows 2003 64bit IDS 11.50 FC5 system to 11.50 FC7. > After the upgrade which went without incident we no longer see all the > databases in the Auto Update Statistics. We thought it was OAT so upgrade > that > to 2.28 from 2.26 no change. We are only seeing the sysutil, sysuser and > one > production database which does not give us any statistics like it use to or > how the sys databases do. Have tried reseting the sysadmin no change. Have > also rebuild the sysmaster with no luck. If i querry the > sysmaster.sysdatabses > i see all the databases and even under dbacces but for some reason they are > not beign picked up by the AUS. > Has anyone see this or is there something we can do to get them back?? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --0016364ec836764060048e922626

Yes the two application database are both Buffered the Sys database are as created by the install/upgrade. It was working prior to the update. John A. Chauvin Sr. Technical Consultant MEDIWARE INFORMATION SYSTEMS Office: (913) 307-1029 Mobile: (913) 489-1054 Fax: (913) 307-1111 John.Chauvin@mediware.com Customer Satisfaction is a top priority for Mediware. We invite you to share your objective views of our performance by clicking here. Your responses will be vital to the focus of our ongoing improvement efforts. This message (including any attachments) constitutes a confidential and/or privileged communication and/or contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, please notify the sender by return email and delete this message and any attachments. Any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. Nothing in this email is intended to create a binding agreement between Mediware Information Systems, Inc. and any third party. > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Fernando Nunes > Sent: Tuesday, August 24, 2010 08:58 > To: ids@iiug.org > Subject: Re: Databases not showing up in AUS [21028] > > The databases have logging? > Regards. > > On Tue, Aug 24, 2010 at 2:42 PM, JOHN A. CHAUVIN > <john.chauvin@mediware.com>wrote: > > > I recently upgrade a Windows 2003 64bit IDS 11.50 FC5 system to 11.50 FC7. > > After the upgrade which went without incident we no longer see all the > > databases in the Auto Update Statistics. We thought it was OAT so upgrade > > that > > to 2.28 from 2.26 no change. We are only seeing the sysutil, sysuser and > > one > > production database which does not give us any statistics like it use to or > > how the sys databases do. Have tried reseting the sysadmin no change. Have > > also rebuild the sysmaster with no luck. If i querry the > > sysmaster.sysdatabses > > i see all the databases and even under dbacces but for some reason they are > > not beign picked up by the AUS. > > Has anyone see this or is there something we can do to get them back?? > > > > > > > > > ************************************************************************ ******* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > -- > Fernando Nunes > Portugal > > http://informix-technology.blogspot.com > My email works... but I don't check it frequently... > > --0016364ec836764060048e922626 > > > ************************************************************************ ******* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Here is the output for the logging status name sysutils is_logging 1 is_buff_log 0 is_ansi 0 is_nls 0 name sysuser is_logging 1 is_buff_log 0 is_ansi 0 is_nls 0 name worx_prod is_logging 1 is_buff_log 1 is_ansi 0 is_nls 0 name chromis is_logging 1 is_buff_log 1 is_ansi 0 is_nls 0 name sysadmin is_logging 1 is_buff_log 0 is_ansi 0 is_nls 0 name sysmaster is_logging 1 is_buff_log 0 is_ansi 0 is_nls 0 6 row(s) retrieved. John A. Chauvin

I took a look at the OAT code. It should only show information after the evaluation task has run, which probably didn't happen yet... Regards. On Tue, Aug 24, 2010 at 3:15 PM, John Chauvin <John.Chauvin@mediware.com>wrote: > Yes the two application database are both Buffered the Sys database are > as created by the install/upgrade. It was working prior to the update. > > John A. Chauvin > Sr. Technical Consultant > MEDIWARE INFORMATION SYSTEMS > > Office: (913) 307-1029 > Mobile: (913) 489-1054 > Fax: (913) 307-1111 > John.Chauvin@mediware.com > > Customer Satisfaction is a top priority for Mediware. > We invite you to share your objective views of our performance by > clicking here. Your responses will be vital to the focus of our ongoing > improvement efforts. > > This message (including any attachments) constitutes a confidential > and/or privileged communication and/or contains confidential information > intended for a specific individual and purpose, and is protected by law. > If you are not the intended recipient, please notify the sender by > return email and delete this message and any attachments. Any > disclosure, copying, or distribution of this message, or the taking of > any action based on it, is strictly prohibited. Nothing in this email is > intended to create a binding agreement between Mediware Information > Systems, Inc. and any third party. > > > -----Original Message----- > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > > Fernando Nunes > > Sent: Tuesday, August 24, 2010 08:58 > > To: ids@iiug.org > > Subject: Re: Databases not showing up in AUS [21028] > > > > The databases have logging? > > Regards. > > > > On Tue, Aug 24, 2010 at 2:42 PM, JOHN A. CHAUVIN > > <john.chauvin@mediware.com>wrote: > > > > > I recently upgrade a Windows 2003 64bit IDS 11.50 FC5 system to > 11.50 FC7. > > > After the upgrade which went without incident we no longer see all > the > > > databases in the Auto Update Statistics. We thought it was OAT so > upgrade > > > that > > > to 2.28 from 2.26 no change. We are only seeing the sysutil, sysuser > and > > > one > > > production database which does not give us any statistics like it > use to or > > > how the sys databases do. Have tried reseting the sysadmin no > change. Have > > > also rebuild the sysmaster with no luck. If i querry the > > > sysmaster.sysdatabses > > > i see all the databases and even under dbacces but for some reason > they are > > > not beign picked up by the AUS. > > > Has anyone see this or is there something we can do to get them > back?? > > > > > > > > > > > > > > > ************************************************************************ > ******* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > -- > > Fernando Nunes > > Portugal > > > > http://informix-technology.blogspot.com > > My email works... but I don't check it frequently... > > > > --0016364ec836764060048e922626 > > > > > > > ************************************************************************ > ******* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --0016e64e91aa5276a6048e92c7e9

I have run the Clean up and the Evaluation both from the OAT still no luck John A. Chauvin > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Fernando Nunes > Sent: Tuesday, August 24, 2010 09:43 > To: ids@iiug.org > Subject: Re: Databases not showing up in AUS [21037] > > I took a look at the OAT code. It should only show information after the > evaluation task has run, which probably didn't happen yet... > Regards. > > On Tue, Aug 24, 2010 at 3:15 PM, John Chauvin > <John.Chauvin@mediware.com>wrote: > > > Yes the two application database are both Buffered the Sys database are > > as created by the install/upgrade. It was working prior to the update. > > > > John A. Chauvin > > Sr. Technical Consultant > > MEDIWARE INFORMATION SYSTEMS > > > > Office: (913) 307-1029 > > Mobile: (913) 489-1054 > > Fax: (913) 307-1111 > > John.Chauvin@mediware.com > > > > Customer Satisfaction is a top priority for Mediware. > > We invite you to share your objective views of our performance by > > clicking here. Your responses will be vital to the focus of our ongoing > > improvement efforts. > > > > This message (including any attachments) constitutes a confidential > > and/or privileged communication and/or contains confidential information > > intended for a specific individual and purpose, and is protected by law. > > If you are not the intended recipient, please notify the sender by > > return email and delete this message and any attachments. Any > > disclosure, copying, or distribution of this message, or the taking of > > any action based on it, is strictly prohibited. Nothing in this email is > > intended to create a binding agreement between Mediware Information > > Systems, Inc. and any third party. > > > > > -----Original Message----- > > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > > > Fernando Nunes > > > Sent: Tuesday, August 24, 2010 08:58 > > > To: ids@iiug.org > > > Subject: Re: Databases not showing up in AUS [21028] > > > > > > The databases have logging? > > > Regards. > > > > > > On Tue, Aug 24, 2010 at 2:42 PM, JOHN A. CHAUVIN > > > <john.chauvin@mediware.com>wrote: > > > > > > > I recently upgrade a Windows 2003 64bit IDS 11.50 FC5 system to > > 11.50 FC7. > > > > After the upgrade which went without incident we no longer see all > > the > > > > databases in the Auto Update Statistics. We thought it was OAT so > > upgrade > > > > that > > > > to 2.28 from 2.26 no change. We are only seeing the sysutil, sysuser > > and > > > > one > > > > production database which does not give us any statistics like it > > use to or > > > > how the sys databases do. Have tried reseting the sysadmin no > > change. Have > > > > also rebuild the sysmaster with no luck. If i querry the > > > > sysmaster.sysdatabses > > > > i see all the databases and even under dbacces but for some reason > > they are > > > > not beign picked up by the AUS. > > > > Has anyone see this or is there something we can do to get them > > back?? > > > > > > > > > > > > > > > > > > > > > ************************************************************************ > > ******* > > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > > > -- > > > Fernando Nunes > > > Portugal > > > > > > http://informix-technology.blogspot.com > > > My email works... but I don't check it frequently... > > > > > > --0016364ec836764060048e922626 > > > > > > > > > > > ************************************************************************ > > ******* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > ************************************************************************ ******* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > -- > Fernando Nunes > Portugal > > http://informix-technology.blogspot.com > My email works... but I don't check it frequently... > > --0016e64e91aa5276a6048e92c7e9 > > > ************************************************************************ ******* > Forum Note: Use "Reply" to post a response in the discussion forum. >

I think the query that generates the bottom table of that page is this one: $qry = "SELECT aus_ci_stime, aus_ci_database, " . " aus_ci_missed_tables, " . " decode(aus_ci_need_tables,0,0," . " (select count(unique aus_cmd_partnum)" . " from sysadmin:aus_cmd_list" . " where aus_cmd_priority > 100000" . " and aus_cmd_dbs_partnum = aus_ci_dbs_partnum)" . " ) as small_tables," . " aus_ci_need_tables - aus_ci_done_tables - decode(aus_ci_need_tables,0,0," . " (select count(unique aus_cmd_partnum)" . " from sysadmin:aus_cmd_list" . " where aus_cmd_priority > 100000" . " and aus_cmd_dbs_partnum = aus_ci_dbs_partnum)" . " ) as large_tables," . " aus_ci_done_tables " . " FROM sysadmin:aus_cmd_info " . " WHERE aus_ci_database IS NOT NULL" Maybe you want to try it and find out where it's breaking.... On Tue, Aug 24, 2010 at 3:48 PM, John Chauvin <John.Chauvin@mediware.com>wrote: > I have run the Clean up and the Evaluation both from the OAT still no > luck > > John A. Chauvin > > -----Original Message----- > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > > Fernando Nunes > > Sent: Tuesday, August 24, 2010 09:43 > > To: ids@iiug.org > > Subject: Re: Databases not showing up in AUS [21037] > > > > I took a look at the OAT code. It should only show information after > the > > evaluation task has run, which probably didn't happen yet... > > Regards. > > > > On Tue, Aug 24, 2010 at 3:15 PM, John Chauvin > > <John.Chauvin@mediware.com>wrote: > > > > > Yes the two application database are both Buffered the Sys database > are > > > as created by the install/upgrade. It was working prior to the > update. > > > > > > John A. Chauvin > > > Sr. Technical Consultant > > > MEDIWARE INFORMATION SYSTEMS > > > > > > Office: (913) 307-1029 > > > Mobile: (913) 489-1054 > > > Fax: (913) 307-1111 > > > John.Chauvin@mediware.com > > > > > > Customer Satisfaction is a top priority for Mediware. > > > We invite you to share your objective views of our performance by > > > clicking here. Your responses will be vital to the focus of our > ongoing > > > improvement efforts. > > > > > > This message (including any attachments) constitutes a confidential > > > and/or privileged communication and/or contains confidential > information > > > intended for a specific individual and purpose, and is protected by > law. > > > If you are not the intended recipient, please notify the sender by > > > return email and delete this message and any attachments. Any > > > disclosure, copying, or distribution of this message, or the taking > of > > > any action based on it, is strictly prohibited. Nothing in this > email is > > > intended to create a binding agreement between Mediware Information > > > Systems, Inc. and any third party. > > > > > > > -----Original Message----- > > > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf > Of > > > > Fernando Nunes > > > > Sent: Tuesday, August 24, 2010 08:58 > > > > To: ids@iiug.org > > > > Subject: Re: Databases not showing up in AUS [21028] > > > > > > > > The databases have logging? > > > > Regards. > > > > > > > > On Tue, Aug 24, 2010 at 2:42 PM, JOHN A. CHAUVIN > > > > <john.chauvin@mediware.com>wrote: > > > > > > > > > I recently upgrade a Windows 2003 64bit IDS 11.50 FC5 system to > > > 11.50 FC7. > > > > > After the upgrade which went without incident we no longer see > all > > > the > > > > > databases in the Auto Update Statistics. We thought it was OAT > so > > > upgrade > > > > > that > > > > > to 2.28 from 2.26 no change. We are only seeing the sysutil, > sysuser > > > and > > > > > one > > > > > production database which does not give us any statistics like > it > > > use to or > > > > > how the sys databases do. Have tried reseting the sysadmin no > > > change. Have > > > > > also rebuild the sysmaster with no luck. If i querry the > > > > > sysmaster.sysdatabses > > > > > i see all the databases and even under dbacces but for some > reason > > > they are > > > > > not beign picked up by the AUS. > > > > > Has anyone see this or is there something we can do to get them > > > back?? > > > > > > > > > > > > > > > > > > > > > > > > > > > > ************************************************************************ > > > ******* > > > > > Forum Note: Use "Reply" to post a response in the discussion > forum. > > > > > > > > > > > > > > > > > > -- > > > > Fernando Nunes > > > > Portugal > > > > > > > > http://informix-technology.blogspot.com > > > > My email works... but I don't check it frequently... > > > > > > > > --0016364ec836764060048e922626 > > > > > > > > > > > > > > > > ************************************************************************ > > > ******* > > > > Forum Note: Use "Reply" to post a response in the discussion > forum. > > > > > > > > > > > > > > > > > > > ************************************************************************ > ******* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > -- > > Fernando Nunes > > Portugal > > > > http://informix-technology.blogspot.com > > My email works... but I don't check it frequently... > > > > --0016e64e91aa5276a6048e92c7e9 > > > > > > > ************************************************************************ > ******* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --0016364eec0aa4ea7c048e954d8f

I am jumping in a little late, but can you please explain what you mean by "not showing up"? Is it not showing up in OAT main screen, not in the list of commands generated, or other?? John F. Miller III STSM, Support Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 08/24/2010 07:48:16 AM: > [image removed] > > RE: Databases not showing up in AUS [21038] > > John Chauvin > > to: > > ids > > 08/24/2010 07:51 AM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > I have run the Clean up and the Evaluation both from the OAT still no > luck > > John A. Chauvin > > -----Original Message----- > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > > Fernando Nunes > > Sent: Tuesday, August 24, 2010 09:43 > > To: ids@iiug.org > > Subject: Re: Databases not showing up in AUS [21037] > > > > I took a look at the OAT code. It should only show information after > the > > evaluation task has run, which probably didn't happen yet... > > Regards. > > > > On Tue, Aug 24, 2010 at 3:15 PM, John Chauvin > > <John.Chauvin@mediware.com>wrote: > > > > > Yes the two application database are both Buffered the Sys database > are > > > as created by the install/upgrade. It was working prior to the > update. > > > > > > John A. Chauvin > > > Sr. Technical Consultant > > > MEDIWARE INFORMATION SYSTEMS > > > > > > Office: (913) 307-1029 > > > Mobile: (913) 489-1054 > > > Fax: (913) 307-1111 > > > John.Chauvin@mediware.com > > > > > > Customer Satisfaction is a top priority for Mediware. > > > We invite you to share your objective views of our performance by > > > clicking here. Your responses will be vital to the focus of our > ongoing > > > improvement efforts. > > > > > > This message (including any attachments) constitutes a confidential > > > and/or privileged communication and/or contains confidential > information > > > intended for a specific individual and purpose, and is protected by > law. > > > If you are not the intended recipient, please notify the sender by > > > return email and delete this message and any attachments. Any > > > disclosure, copying, or distribution of this message, or the taking > of > > > any action based on it, is strictly prohibited. Nothing in this > email is > > > intended to create a binding agreement between Mediware Information > > > Systems, Inc. and any third party. > > > > > > > -----Original Message----- > > > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf > Of > > > > Fernando Nunes > > > > Sent: Tuesday, August 24, 2010 08:58 > > > > To: ids@iiug.org > > > > Subject: Re: Databases not showing up in AUS [21028] > > > > > > > > The databases have logging? > > > > Regards. > > > > > > > > On Tue, Aug 24, 2010 at 2:42 PM, JOHN A. CHAUVIN > > > > <john.chauvin@mediware.com>wrote: > > > > > > > > > I recently upgrade a Windows 2003 64bit IDS 11.50 FC5 system to > > > 11.50 FC7. > > > > > After the upgrade which went without incident we no longer see > all > > > the > > > > > databases in the Auto Update Statistics. We thought it was OAT > so > > > upgrade > > > > > that > > > > > to 2.28 from 2.26 no change. We are only seeing the sysutil, > sysuser > > > and > > > > > one > > > > > production database which does not give us any statistics like > it > > > use to or > > > > > how the sys databases do. Have tried reseting the sysadmin no > > > change. Have > > > > > also rebuild the sysmaster with no luck. If i querry the > > > > > sysmaster.sysdatabses > > > > > i see all the databases and even under dbacces but for some > reason > > > they are > > > > > not beign picked up by the AUS. > > > > > Has anyone see this or is there something we can do to get them > > > back?? > > > > > > > > > > > > > > > > > > > > > > > > > > > > ************************************************************************ > > > ******* > > > > > Forum Note: Use "Reply" to post a response in the discussion > forum. > > > > > > > > > > > > > > > > > > -- > > > > Fernando Nunes > > > > Portugal > > > > > > > > http://informix-technology.blogspot.com > > > > My email works... but I don't check it frequently... > > > > > > > > --0016364ec836764060048e922626 > > > > > > > > > > > > > > > > ************************************************************************ > > > ******* > > > > Forum Note: Use "Reply" to post a response in the discussion > forum. > > > > > > > > > > > > > > > > > > > ************************************************************************ > ******* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > -- > > Fernando Nunes > > Portugal > > > > http://informix-technology.blogspot.com > > My email works... but I don't check it frequently... > > > > --0016e64e91aa5276a6048e92c7e9 > > > > > > > ************************************************************************ > ******* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

John It's not showing in the list of databases in OAT on the Auto Update Statistics page and I checked the aus_cmd_info table and it only has three of the five database in it (same as the page). John A. Chauvin > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of John > Miller iii > Sent: Tuesday, August 24, 2010 12:51 > To: ids@iiug.org > Subject: RE: Databases not showing up in AUS [21046] > > I am jumping in a little late, but can you please explain what you mean by > "not showing up"? Is it not showing up in OAT main screen, not in the > list of commands generated, or other?? > > John F. Miller III > STSM, Support Architect > miller3@us.ibm.com > 503-578-5645 > IBM Informix Dynamic Server (IDS) > > ids-bounces@iiug.org wrote on 08/24/2010 07:48:16 AM: > > > [image removed] > > > > RE: Databases not showing up in AUS [21038] > > > > John Chauvin > > > > to: > > > > ids > > > > 08/24/2010 07:51 AM > > > > Sent by: > > > > ids-bounces@iiug.org > > > > Please respond to ids > > > > I have run the Clean up and the Evaluation both from the OAT still no > > luck > > > > John A. Chauvin > > > -----Original Message----- > > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > > > Fernando Nunes > > > Sent: Tuesday, August 24, 2010 09:43 > > > To: ids@iiug.org > > > Subject: Re: Databases not showing up in AUS [21037] > > > > > > I took a look at the OAT code. It should only show information after > > the > > > evaluation task has run, which probably didn't happen yet... > > > Regards. > > > > > > On Tue, Aug 24, 2010 at 3:15 PM, John Chauvin > > > <John.Chauvin@mediware.com>wrote: > > > > > > > Yes the two application database are both Buffered the Sys database > > are > > > > as created by the install/upgrade. It was working prior to the > > update. > > > > > > > > John A. Chauvin > > > > Sr. Technical Consultant > > > > MEDIWARE INFORMATION SYSTEMS > > > > > > > > Office: (913) 307-1029 > > > > Mobile: (913) 489-1054 > > > > Fax: (913) 307-1111 > > > > John.Chauvin@mediware.com > > > > > > > > Customer Satisfaction is a top priority for Mediware. > > > > We invite you to share your objective views of our performance by > > > > clicking here. Your responses will be vital to the focus of our > > ongoing > > > > improvement efforts. > > > > > > > > This message (including any attachments) constitutes a confidential > > > > and/or privileged communication and/or contains confidential > > information > > > > intended for a specific individual and purpose, and is protected by > > law. > > > > If you are not the intended recipient, please notify the sender by > > > > return email and delete this message and any attachments. Any > > > > disclosure, copying, or distribution of this message, or the taking > > of > > > > any action based on it, is strictly prohibited. Nothing in this > > email is > > > > intended to create a binding agreement between Mediware Information > > > > Systems, Inc. and any third party. > > > > > > > > > -----Original Message----- > > > > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf > > Of > > > > > Fernando Nunes > > > > > Sent: Tuesday, August 24, 2010 08:58 > > > > > To: ids@iiug.org > > > > > Subject: Re: Databases not showing up in AUS [21028] > > > > > > > > > > The databases have logging? > > > > > Regards. > > > > > > > > > > On Tue, Aug 24, 2010 at 2:42 PM, JOHN A. CHAUVIN > > > > > <john.chauvin@mediware.com>wrote: > > > > > > > > > > > I recently upgrade a Windows 2003 64bit IDS 11.50 FC5 system to > > > > 11.50 FC7. > > > > > > After the upgrade which went without incident we no longer see > > all > > > > the > > > > > > databases in the Auto Update Statistics. We thought it was OAT > > so > > > > upgrade > > > > > > that > > > > > > to 2.28 from 2.26 no change. We are only seeing the sysutil, > > sysuser > > > > and > > > > > > one > > > > > > production database which does not give us any statistics like > > it > > > > use to or > > > > > > how the sys databases do. Have tried reseting the sysadmin no > > > > change. Have > > > > > > also rebuild the sysmaster with no luck. If i querry the > > > > > > sysmaster.sysdatabses > > > > > > i see all the databases and even under dbacces but for some > > reason > > > > they are > > > > > > not beign picked up by the AUS. > > > > > > Has anyone see this or is there something we can do to get them > > > > back?? > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ************************************************************************ > > > > ******* > > > > > > Forum Note: Use "Reply" to post a response in the discussion > > forum. > > > > > > > > > > > > > > > > > > > > > > -- > > > > > Fernando Nunes > > > > > Portugal > > > > > > > > > > http://informix-technology.blogspot.com > > > > > My email works... but I don't check it frequently... > > > > > > > > > > --0016364ec836764060048e922626 > > > > > > > > > > > > > > > > > > > > > ************************************************************************ > > > > ******* > > > > > Forum Note: Use "Reply" to post a response in the discussion > > forum. > > > > > > > > > > > > > > > > > > > > > > > > > > ************************************************************************ > > ******* > > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > > > -- > > > Fernando Nunes > > > Portugal > > > > > > http://informix-technology.blogspot.com > > > My email works... but I don't check it frequently... > > > > > > --0016e64e91aa5276a6048e92c7e9 > > > > > > > > > > > ************************************************************************ > > ******* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > ************************************************************************ ******* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > ************************************************************************ ******* > Forum Note: Use "Reply" to post a response in the discussion forum. >

I opened a case with support will see what happens. In the mean time I dropped and rebuilt the sysadmin using the sql's from the INFORMIXDIR\\\\etc\\\\sysadmin folder. Now I have all but one application database populating the aus_cmd_info table. John A. Chauvin > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of John > Chauvin > Sent: Tuesday, August 24, 2010 13:19 > To: ids@iiug.org > Subject: RE: Databases not showing up in AUS [21049] > > John > It's not showing in the list of databases in OAT on the Auto Update > Statistics page and I checked the aus_cmd_info table and it only has > three of the five database in it (same as the page). > > John A. Chauvin > > -----Original Message----- > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > John > > Miller iii > > Sent: Tuesday, August 24, 2010 12:51 > > To: ids@iiug.org > > Subject: RE: Databases not showing up in AUS [21046] > > > > I am jumping in a little late, but can you please explain what you > mean by > > "not showing up"? Is it not showing up in OAT main screen, not in the > > list of commands generated, or other?? > > > > John F. Miller III > > STSM, Support Architect > > miller3@us.ibm.com > > 503-578-5645 > > IBM Informix Dynamic Server (IDS) > > > > ids-bounces@iiug.org wrote on 08/24/2010 07:48:16 AM: > > > > > [image removed] > > > > > > RE: Databases not showing up in AUS [21038] > > > > > > John Chauvin > > > > > > to: > > > > > > ids > > > > > > 08/24/2010 07:51 AM > > > > > > Sent by: > > > > > > ids-bounces@iiug.org > > > > > > Please respond to ids > > > > > > I have run the Clean up and the Evaluation both from the OAT still > no > > > luck > > > > > > John A. Chauvin > > > > -----Original Message----- > > > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf > Of > > > > Fernando Nunes > > > > Sent: Tuesday, August 24, 2010 09:43 > > > > To: ids@iiug.org > > > > Subject: Re: Databases not showing up in AUS [21037] > > > > > > > > I took a look at the OAT code. It should only show information > after > > > the > > > > evaluation task has run, which probably didn't happen yet... > > > > Regards. > > > > > > > > On Tue, Aug 24, 2010 at 3:15 PM, John Chauvin > > > > <John.Chauvin@mediware.com>wrote: > > > > > > > > > Yes the two application database are both Buffered the Sys > database > > > are > > > > > as created by the install/upgrade. It was working prior to the > > > update. > > > > > > > > > > John A. Chauvin > > > > > > -----Original Message----- > > > > > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On > Behalf > > > Of > > > > > > Fernando Nunes > > > > > > Sent: Tuesday, August 24, 2010 08:58 > > > > > > To: ids@iiug.org > > > > > > Subject: Re: Databases not showing up in AUS [21028] > > > > > > > > > > > > The databases have logging? > > > > > > Regards. > > > > > > > > > > > > On Tue, Aug 24, 2010 at 2:42 PM, JOHN A. CHAUVIN > > > > > > <john.chauvin@mediware.com>wrote: > > > > > > > > > > > > > I recently upgrade a Windows 2003 64bit IDS 11.50 FC5 system > to > > > > > 11.50 FC7. > > > > > > > After the upgrade which went without incident we no longer > see > > > all > > > > > the > > > > > > > databases in the Auto Update Statistics. We thought it was > OAT > > > so > > > > > upgrade > > > > > > > that > > > > > > > to 2.28 from 2.26 no change. We are only seeing the sysutil, > > > sysuser > > > > > and > > > > > > > one > > > > > > > production database which does not give us any statistics > like > > > it > > > > > use to or > > > > > > > how the sys databases do. Have tried reseting the sysadmin > no > > > > > change. Have > > > > > > > also rebuild the sysmaster with no luck. If i querry the > > > > > > > sysmaster.sysdatabses > > > > > > > i see all the databases and even under dbacces but for some > > > reason > > > > > they are > > > > > > > not beign picked up by the AUS. > > > > > > > Has anyone see this or is there something we can do to get > them > > > > > back?? > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ************************************************************************ > > > > > ******* > > > > > > > Forum Note: Use "Reply" to post a response in the discussion > > > forum. > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > Fernando Nunes > > > > > > Portugal > > > > > > > > > > > > http://informix-technology.blogspot.com > > > > > > My email works... but I don't check it frequently... > > > > > > > > > > > > --0016364ec836764060048e922626 > > > > > > > > > > > > > > > > > > > > > > > > > > > ************************************************************************ > > > > > ******* > > > > > > Forum Note: Use "Reply" to post a response in the discussion > > > forum. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ************************************************************************ > > > ******* > > > > > Forum Note: Use "Reply" to post a response in the discussion > forum. > > > > > > > > > > > > > > > > > > -- > > > > Fernando Nunes > > > > Portugal > > > > > > > > http://informix-technology.blogspot.com > > > > My email works... but I don't check it frequently... > > > > > > > > --0016e64e91aa5276a6048e92c7e9 > > > > > > > > > > > > > > > > ************************************************************************ > > > ******* > > > > Forum Note: Use "Reply" to post a response in the discussion > forum. > > > > > > > > > > > > > > > > > > ************************************************************************ > ******* > > > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > ************************************************************************ > ******* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > ************************************************************************ ******* > Forum Note: Use "Reply" to post a response in the discussion forum. >