Save 
Join IIUG
 for   
 

Informix News
18 Nov 13 - ZDNet - Top 20 mobile skills in demand... Read
09 Sep 13 - telecompaper - Shaspa and Tatung have shown a new smart home platform at Ifa in Berlin. Powered by the IBM Informix software... Read
06 Sep 13 - IBM data magazine - Mission Accomplished - Miami, Florida will be the backdrop for the 2014 IIUG Informix Conference... Read
01 Feb 13 - IBM Data Magazine - Are your database backups safe? Lester Knutsen (IBM Champion) writes about database back up safety using "archecker"... Read
14 Nov 12 - IBM - IBM's Big Data For Smart Grid Goes Live In Texas... Read
3 Oct 12 - The Financial - IBM and TransWorks Collaborate to Help Louisiana-Pacific Corporation Achieve Supply Chain Efficiency... Read
28 Aug 12 - techCLOUD9 - Splunk kicks up a SaaS Storm... Read
10 Aug 12 - businessCLOUD9 - Is this the other half of Cloud monitoring?... Read
3 Aug 12 - IBM data management - Supercharging the data warehouse while keeping costs down IBM Informix Warehouse Accelerator (IWA) delivers superior performance for in-memory analytics processing... Read
2 Aug 12 - channelbiz - Oninit Group launches Pay Per Pulse cloud-based service... Read
28 May 12 - Bloor - David Norfolk on the recent Informix benchmark "pretty impressive results"... Read
23 May 12 - DBTA - Informix Genero: A Way to Modernize Informix 4GL Applications... Read
9 Apr 12 - Mastering Data Management - Upping the Informix Ante: Advanced Data Tools... Read
22 Mar 12 - developerWorks - Optimizing Informix database access... Read
14 Mar 12 - BernieSpang.com - International Informix User Group set to meet in San Diego... Read
1 Mar 12 - IBM Data Management - IIUG Heads West for 2012 - Get ready for sun and sand in San Diego... Read
1 Mar 12 - IBM Data Management - Running Informix on Solid-State Drives.Speed Up Database Access... Read
26 Feb 12 - BernieSpan.com - Better results, lower cost for a broad set of new IBM clients and partners... Read
24 Feb 12 - developerWorks - Informix Warehouse Accelerator: Continuous Acceleration during Data Refresh... Read
6 Feb 12 - PRLOG - Informix port delivers unlimited database scalability for popular SaaS application ... Read
2 Feb 12 - developerWorks - Loading data with the IBM Informix TimeSeries Plug-in for Data Studio... Read
1 Feb 12 - developerWorks - 100 Tech Tips, #47: Log-in to Fix Central... Read
13 Jan 12 - MC Press online - Informix Dynamic Server Entices New Users with Free Production Edition ... Read
11 Jan 12 - Computerworld - Ecologic Analytics and Landis+Gyr -- Suitors Decide to Tie the Knot... Read
9 Jan 12 - planetIDS.com - DNS impact on Informix / Impacto do DNS no Informix... Read
8 Sep 11 - TMCnet.com - IBM Offers Database Solution to Enable Smart Meter Data Capture... Read
1 Aug 11 - IBM Data Management Magazine - IIUG user view: Happy 10th anniversary to IBM and Informix... Read
8 Jul 11 - Database Trends and Applications - Managing Time Series Data with Informix... Read
31 May 11 - Smart Grid - The meter data management pitfall utilities are overlooking... Read
27 May 11 - IBM Data Management Magazine - IIUG user view: Big data, big time ( Series data, warehouse acceleration, and 4GLs )... Read
16 May 11 - Business Wire - HiT Software Announces DBMoto for Enterprise Integration, Adds Informix. Log-based Change Data Capture... Read
21 Mar 11 - Yahoo! Finance - IBM and Cable&Wireless Worldwide Announce UK Smart Energy Cloud... Read
14 Mar 11 - MarketWatch - Fuzzy Logix and IBM Unveil In-Database Analytics for IBM Informix... Read
11 Mar 11 - InvestorPlace - It's Time to Give IBM Props: How many tech stocks are up 53% since the dot-com boom?... Read
9 Mar 11 - DBTA - Database Administration and the Goal of Diminishing Downtime... Read
2 Feb 11 - DBTAs - Informix 11.7 Flexible Grid Provides a Different Way of Looking at Database Servers... Read
27 Jan 11 - exactsolutions - Exact to Add Informix Support to Database Replay, SQL Monitoring Solutions... Read
25 Jan 11 - PR Newswire - Bank of China in the UK Works With IBM to Become a Smarter, Greener Bank... Read
12 Oct 10 - Database Trends and Applications - Informix 11.7: The Beginning of the Next Decade of IBM Informix... Read
20 Sep 10 - planetIDS.com - ITG analyst paper: Cost/Benefit case for IBM Informix as compared to Microsoft SQL Server... Read
20 Jul 10 - IBM Announcements - IBM Informix Choice Edition V11.50 helps deploy low-cost scalable and reliable solutions for Apple Macintosh and Microsoft Windows... Read
20 Jul 10 - IBM Announcements - Software withdrawal: Elite Support for Informix Ultimate-C Edition... Read
24 May 10 - eWeek Europe - IBM Supplies Database Tech For EU Smart Grid... Read
23 May 10 - SiliconIndia - IBM's smart metering system allows wise use of energy... Read
21 May 10 - CNET - IBM to help people monitor energy use... Read
20 May 10 - ebiz - IBM Teams With Hildebrand To Bring Smart Metering To Homes Across Britain... Read
19 May 10 - The New Blog Times - Misurare il consumo energetico: DEHEMS è pronto... Read
19 May 10 - ZDNet - IBM software in your home? Pact enables five-city smart meter pilot in Europe... Read
17 March 10 - ZDNet (blog) David Morgenstern - TCO: New research finds Macs in the enterprise easier, cheaper to manage than... Read
17 March 2010 - Virtualization Review - ...key components of Big Blue's platform to the commercial cloud such as its WebSphere suite of application ser vers and its DB2 and Informix databases... Read
10 February 2010 - The Wall Street Journal - International Business Machines is expanding an initiative to win over students and professors on its products. How do they lure the college crowd?... Read


End of Support Dates

IIUG on Facebook IIUG on Twitter

RSS Feed: IIUG Forum: Admin Tools

More IIUG RSS Feeds

The admin-tools forum is for discussing the Informix database administration tools. These are primarily the Informix Server Administrator (ISA), and Server Studio from AGS.


URL: http://www.iiug.org/rss/admin-tools.rss

Below is the latest content available from this feed:

need your pieseof advice
Posted by: k7nirmala@yahoo.com (k7nirmala) - Fri, 23 Sep 2016 09:24:28 EDT
Hi,



I couldn't decide which model of phone to buy so I decided to ask you, please

take a look <http://superb.kristengreim.com/e4dbmw>



Faithfully, k7nirmala

~SUBJECT=need your advice

Hi,



I've found something interesting and need your opinion about that stuff,

please take a look <http://superb.kristengreim.com/e4dbmw>



Faithfully, k7nirmala









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to admin-tools@iiug.org

2. Include the bracketed message number in the subject line: [3724]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: dostats V1.50 --distributions-high
Posted by: art.kagel@gmail.com (Art Kagel) - Tue, 08 Mar 2016 14:38:34 EST
There is a long standing unresolved debate about this. I hold that you need

to perform a LOW on each complete index key separate from the HIGH on the

lead column(s) of the key. John Miller leads the other camp which claims

that this is not necessary. Dostats, because I wrote it and maintain it,

follows my conviction and includes the LOWs that you observed.. The

engine's Auto Update Statistics (AUS), since John wrote that, follows his

convictions and does not perform the LOWs (it also does not produce

distributions for non-indexed columns at all by default).



I have spoken to optimizer developers who agree with John and those who

agree with me, so this is unresolved from a technical standpoint.

Personally, I know that when there is a performance problem that I can

trace to insufficiently detailed data distributions, and when those

distributions are maintained by AUS, more often than not I find that

running dostats fixes the problem. So, it will continue to do what it does.



If you want to eliminate the LOWs, use -I -M rather than the default (

which is equivalent to -I -M -C : Looks like the usage description needs to

be updated. The listed default is very old.) BTW that's an 'eye' not an

'el'.



Art



Art S. Kagel, President and Principal Consultant

ASK Database Management

www.askdbmgt.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 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 Tue, Mar 8, 2016 at 2:07 PM, MARC HONORE <marc.honore@chirec.be> wrote:



> I tried again a few times and i think the problem was a just missing end of

> line before the end of file :'(

>

> Problem solved, thanx a lot :)

>

> (Last thing i don't get is why dostats is doing an update stat LOW on a

> column

> when it's going to do an update stat HIGH on it shortly afterwards? i

> thought

> it was unnecessary (plus it cost a little time on huge tables (and we had

> lots

> of problems with LOW mode and complex outter join on informix 12)))

>

>

>

>



>

>

>

>



--001a113ee4fc5e2b4e052d8eb92f









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to admin-tools@iiug.org

2. Include the bracketed message number in the subject line: [3723]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: dostats V1.50 --distributions-high
Posted by: marc.honore@chirec.be (MARC HONORE) - Tue, 08 Mar 2016 14:08:00 EST
I tried again a few times and i think the problem was a just missing end of

line before the end of file :'(



Problem solved, thanx a lot :)



(Last thing i don't get is why dostats is doing an update stat LOW on a column

when it's going to do an update stat HIGH on it shortly afterwards? i thought

it was unnecessary (plus it cost a little time on huge tables (and we had lots

of problems with LOW mode and complex outter join on informix 12)))









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to admin-tools@iiug.org

2. Include the bracketed message number in the subject line: [3722]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: dostats V1.50 --distributions-high
Posted by: art.kagel@gmail.com (Art Kagel) - Tue, 08 Mar 2016 09:09:29 EST
Marc:



It works when I try it here. Do this simple test for me:

echo "$dbs sysprocplan palnid" >/tmp/fil



dostats -d $dbs -t sysprocplan -E -Q 100 -w 10 -n 100 --aus-thresholds

--isolation

d -m --distributions-high /dev/null 2>/dev/null

dostats -d $dbs -t sysprocplan -E -Q 100 -w 10 -n 100 --aus-thresholds

--isolation

d -m --distributions-high /tmp/fil 2>/dev/null



You should see output like this:



$ dostats -S -d art -t sysprocplan -E -Q 100 -w 10 -n 100 --aus-thresholds

--isolation d -m --distributions-high /dev/null -f - 2>/dev/null

DATABASE art;

SET ISOLATION DIRTY READ;

SET PDQPRIORITY 100;

UPDATE STATISTICS LOW FOR TABLE sysprocplan (procid, planid, datakey,

seqno);

UPDATE STATISTICS HIGH FOR TABLE sysprocplan (procid) DISTRIBUTIONS ONLY;

UPDATE STATISTICS MEDIUM FOR TABLE sysprocplan (planid, datakey, seqno,

created, datasize, data);



art@galadriel-ii:~/SharedDocuments/Latest Art's Stuff$ dostats -S -d art -t

sysprocplan -E -Q 100 -w 10 -n 100 --aus-thresholds --isolation d -m

--distributions-high fil -f - 2>/dev/null

DATABASE art;

SET ISOLATION DIRTY READ;

SET PDQPRIORITY 100;

UPDATE STATISTICS LOW FOR TABLE sysprocplan (procid, planid, datakey,

seqno);

UPDATE STATISTICS HIGH FOR TABLE sysprocplan (procid, planid) DISTRIBUTIONS

ONLY;

UPDATE STATISTICS MEDIUM FOR TABLE sysprocplan (datakey, seqno, created,

datasize, data);



Note that in the second run, using the non-empty file containing the planid

column, planid is listed in the HIGH distribution command while in the

first run with an empty file it is listed in the MEDIUM command instead.

The output will be the same as the first run if you eliminate the

--distributions-high option altogether.



Let me know if you get different results and post them.



Art



Art S. Kagel, President and Principal Consultant

ASK Database Management

www.askdbmgt.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 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 Tue, Mar 8, 2016 at 7:56 AM, MARC HONORE <marc.honore@chirec.be> wrote:



> Maybe i made a mistake in the command.

> This is how the dostats is called in the initial_script:

>

> dostats -d $dbs -E -Q 100 -w 10 -n 100 --aus-thresholds --time-display

> --drop-distributions --isolation d -m --distributions-high

> /path/to/distributionfile 2>&1

>

>

>

>



>

>

>

>



--047d7bd76bea6b6458052d8a2046









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to admin-tools@iiug.org

2. Include the bracketed message number in the subject line: [3721]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: dostats V1.50 --distributions-high
Posted by: marc.honore@chirec.be (MARC HONORE) - Tue, 08 Mar 2016 07:56:43 EST
Maybe i made a mistake in the command.

This is how the dostats is called in the initial_script:



dostats -d $dbs -E -Q 100 -w 10 -n 100 --aus-thresholds --time-display

--drop-distributions --isolation d -m --distributions-high

/path/to/distributionfile 2>&1









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to admin-tools@iiug.org

2. Include the bracketed message number in the subject line: [3720]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: dostats V1.48 --distributions-high
Posted by: marc.honore@chirec.be (MARC HONORE) - Tue, 08 Mar 2016 07:49:55 EST
I made a mistake in the subject sorry.

I have compiled the following version:

Version: $Id: dostats_ng.ec,v 1.50 2015/09/30 16:41:47 art Exp $









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to admin-tools@iiug.org

2. Include the bracketed message number in the subject line: [3719]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: dostats V1.48 --distributions-high
Posted by: art.kagel@gmail.com (Art Kagel) - Tue, 08 Mar 2016 07:05:36 EST
Marc:



--distributions-high was added in version 1.49 so 1.48 wouldn't have it. Is

that the problem? Or is the subject a typo?



Art



Art S. Kagel, President and Principal Consultant

ASK Database Management

www.askdbmgt.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 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 Tue, Mar 8, 2016 at 5:53 AM, MARC HONORE <marc.honore@chirec.be> wrote:



> Hello, i have a question about dostats:

>

> --distributions-high - Provides the name of a file containing a list of

> columns that should have HIGH distributions regardless of the usual level.

> File lines contain three space separated fields: databasename tablename

> columnname. The order of lines is not important, dostats sorts the list

> after

> reading it.

>

> Can this parameter be used in the "initial_stats.ksh"?

> I tried but it appears to be ignored :'(

>

> Thanx in advance

>

>

>

>



>

>

>

>



--001a113ee4fc784d82052d8865c4









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to admin-tools@iiug.org

2. Include the bracketed message number in the subject line: [3718]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

dostats V1.48 --distributions-high
Posted by: marc.honore@chirec.be (MARC HONORE) - Tue, 08 Mar 2016 05:53:24 EST
Hello, i have a question about dostats:



--distributions-high - Provides the name of a file containing a list of

columns that should have HIGH distributions regardless of the usual level.

File lines contain three space separated fields: databasename tablename

columnname. The order of lines is not important, dostats sorts the list after

reading it.



Can this parameter be used in the "initial_stats.ksh"?

I tried but it appears to be ignored :'(



Thanx in advance









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to admin-tools@iiug.org

2. Include the bracketed message number in the subject line: [3717]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Unsubscribe
Posted by: art.kagel@gmail.com (Art Kagel) - Mon, 16 Nov 2015 03:48:29 EST
Go yo the IIUG site, login as a member, then go to the member's forum pages

to manage your subscriptions.



Art

On Nov 16, 2015 02:59, "José Ramón Zuazua Fernández" <zuazua@cnmv.es> wrote:



> Please I want to unsubscribe from this group.

> Thank you.

> A greeting.

>

> ________________________________

>

> Aviso legal Comisión Nacional del Mercado de Valores

>

> Este mensaje y, en su caso, los ficheros que lleve incorporados, está

> dirigido exclusivamente a su destinatario y es de carácter confidencial. Si

> fuere recibido por error o se tuviere conocimiento del mismo sin ser su

> destinatario, rogamos nos lo comunique por la misma vía o telefónicamente

> (91 585 15 00) y proceda a su destrucción, debiendo abstenerse de utilizar,

> transmitir, divulgar o reproducir la información contenida en el mismo. La

> CNMV se reserva las acciones legales que procedan contra todo tercero que

> acceda de forma ilegítima al contenido de cualquier mensaje externo

> procedente de la entidad

>

> Para información y consultas visite nuestra web: http://www.cnmv.es

>

> Disclaimer - Comisión Nacional del Mercado de Valores

>

> This message, its content and any file attached thereto is for the intended

> recipient only and is confidential. If you have received this e-mail in

> error

> or had access to it, you should note that the information in it is private

> and

> any use thereof is unauthorised. In such an event please notify us by

> e-mail

> or by telephone (+ 34 91 585 15 00). Any reproduction of this e-mail by

> whatsoever means and any transmission or dissemination thereof to other

> persons is prohibited. The Comisión Nacional del Mercado de Valores

> reserves

> the right to take legal action against any persons unlawfully gaining

> access

> to the content of any external message it has emitted

>

> For additional information, please visit our website: http://www.cnmv.es

>

>

>

>



>

>

>

>

>

>



--001a11c30f78daf41c0524a47857









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to admin-tools@iiug.org

2. Include the bracketed message number in the subject line: [3716]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Unsubscribe
Posted by: zuazua@cnmv.es (José Ramón Zuazua Fernández) - Mon, 16 Nov 2015 02:59:20 EST
Please I want to unsubscribe from this group.

Thank you.

A greeting.



________________________________



Aviso legal – Comisión Nacional del Mercado de Valores



Este mensaje y, en su caso, los ficheros que lleve incorporados, está

dirigido exclusivamente a su destinatario y es de carácter confidencial. Si

fuere recibido por error o se tuviere conocimiento del mismo sin ser su

destinatario, rogamos nos lo comunique por la misma vía o telefónicamente

(91 585 15 00) y proceda a su destrucción, debiendo abstenerse de utilizar,

transmitir, divulgar o reproducir la información contenida en el mismo. La

CNMV se reserva las acciones legales que procedan contra todo tercero que

acceda de forma ilegítima al contenido de cualquier mensaje externo

procedente de la entidad



Para información y consultas visite nuestra web: http://www.cnmv.es



Disclaimer - Comisión Nacional del Mercado de Valores



This message, its content and any file attached thereto is for the intended

recipient only and is confidential. If you have received this e-mail in error

or had access to it, you should note that the information in it is private and

any use thereof is unauthorised. In such an event please notify us by e-mail

or by telephone (+ 34 91 585 15 00). Any reproduction of this e-mail by

whatsoever means and any transmission or dissemination thereof to other

persons is prohibited. The Comisión Nacional del Mercado de Valores reserves

the right to take legal action against any persons unlawfully gaining access

to the content of any external message it has emitted



For additional information, please visit our website: http://www.cnmv.es









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to admin-tools@iiug.org

2. Include the bracketed message number in the subject line: [3715]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Data Dictionary
Posted by: art.kagel@gmail.com (Art Kagel) - Sun, 15 Nov 2015 18:27:35 EST
I have a similar 4GL data dictionary app I built years ago that I use from

time to time. The easiest way to modernize the app you have would be to

port it to 4Js Genero or Querix Lycia.



Art



Art S. Kagel, President and Principal Consultant

ASK Database Management

www.askdbmgt.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 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 Sun, Nov 15, 2015 at 6:21 PM, DAVE TOBIN <dave.tobin@reece.com.au> wrote:



> Hi All,

>

> What do you guys use for your IDS data dictionary managers ?

>

> We have a homegrown system that was originally developed with Informix 4GL

> that is in need of a revamp with a modern web style interface. Before we

> spend

> the time to do this I was wondering if there is something good we can get

> off

> the shelf.

>

> Cheers

>

> Dave

>

>

>

>



>

>

>

>



--001a11349ceee92b0e05249ca295









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to admin-tools@iiug.org

2. Include the bracketed message number in the subject line: [3714]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Data Dictionary
Posted by: dave.tobin@reece.com.au (DAVE TOBIN) - Sun, 15 Nov 2015 18:21:04 EST
Hi All,



What do you guys use for your IDS data dictionary managers ?



We have a homegrown system that was originally developed with Informix 4GL

that is in need of a revamp with a modern web style interface. Before we spend

the time to do this I was wondering if there is something good we can get off

the shelf.



Cheers



Dave









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to admin-tools@iiug.org

2. Include the bracketed message number in the subject line: [3713]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: dbaccess bad system menu format
Posted by: pravinebankar@gmail.com (PRAVIN BANKAR) - Fri, 02 Oct 2015 08:03:54 EDT
Hello MOHAMMAD,



Can you please share the more details on error with its code?



Have you referred the logs..?



Thanks,

Pravin Bankar









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to admin-tools@iiug.org

2. Include the bracketed message number in the subject line: [3712]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

dbaccess bad system menu format
Posted by: irfan199@yahoo.com (MOHAMMAD IRFAN) - Thu, 01 Oct 2015 02:13:42 EDT
Hi, I've encountered a strange error when using dbaccess. It says Bad Menu and

System Format. After that it just exit. How to fix this?



Thank you.









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to admin-tools@iiug.org

2. Include the bracketed message number in the subject line: [3711]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

get the lists
Posted by: wanguod@cn.ibm.com (Guo Dong Wan) - Wed, 22 Jul 2015 03:57:20 EDT
To: GUO DONG WAN



E-mail SIGs will be sent to: wanguod@cn.ibm.com



You have signed up for the following e-mail discussion

lists from the IIUG. Note the IIUG in no way edits,

or has any control of the content of these lists



To send e-mail to the list, simply send it to

LISTNAME@iiug.org

so for example, if you are receiving the engine list

Please send e-mail to: engines@iiug.org



You lists:

List Name: classics



Description: The classics discussion list is a forum to discuss all asp=

ects

of Informix classic tools including Standard Engine (SE), Online 5, 4GL=

,

D4GL, ESQL, ISQL and others.



List Name: datablade-list



Description: The datablade list is a discussion list dedicated to the

discussion of Informix DataBlades. This is for both users and developer=

s.



List Name: informix-list



Description: An email discussion list dedicated to all of the Informix

offerings and topics. The list is 'gatewayed' with the Usenet newsgroup=



comp.databases.informix



List Name: linux-informix



Description: An email discussion list for the use of Informix products =

on

Linux.



List Name: admin-tools



Description: The admin-tools email list is for discussing the Informix

database administration tools. These are primarily the Informix Server=



Administrator (ISA), and Server Studio from AGS



List Name: redbrick-list



Description: The Redbrick list is a discussion list for the users of

Informix Redbrick products.



List Name: sapmix



Description: sapmix is a discussion list for Informix products used wit=

h

the SAP product



List Name: xps



Description: A discussion list to communicate about all aspects of the

Extended Parallel Server (XPS) Engine - xps@iiug.org



List Name: ids



Description: A discussion list to communicate about all aspects of the

Informix Dynamic Server (IDS) Engine - ids@iiug.org



List Name: iiug-deu



Description: IIUG in German



List Name: development-tools



Description: A forum for discussion of Informix-related development too=

ls

and applications



List Name: jobs



Description: An email notification list for new jobs posted to the Info=

rmix

Job Board. Please note: this is a one-way list; email messages sent to =

this

list will be disgarded. To respond to a job posting or to post a job, g=

o to

the Informix Job Board.



List Name: spatial-users



Description: Discussion of issues relating to the use of the Informix

Spatial DataBlade Module to store, manipulate, index and analyze

multidimensional spatial data.



List Name: oat



Description: Open Admin Tools discussion forum



List Name: datastudio



Description: A discussion forum dedicated to Data Studio.



webmaster@iiug.org



=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=

=3D=3D=3D=3D

IIUG Home page - http://www.iiug.org



=









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to admin-tools@iiug.org

2. Include the bracketed message number in the subject line: [3710]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Health advisor - can it ignore dbspaces
Posted by: sumanth.r@gmail.com (Sumanth Rajagopal) - Thu, 30 Apr 2015 19:28:03 EDT
Hi,



In the Health Advisor in OAT specific dbspaces can be ignored from the

free space check. In the 'Storage' category, the Alarm, "Dbspace Free

Space" has an exceptions section to list dbspaces to be excluded from the

check.



Regards,

Sumanth.



On Wed, Apr 29, 2015 at 9:42 AM, BILL GLIDDEN <bglidden1962@gmail.com>

wrote:



> My health advisor always gives me red alarms on my plog and llog dbspaces.

> In

> my case, they're both very static and I'm not worried that there is only 1%

> free. Is there a way to have the Health advisor ignore specific dbspaces?

> Or,

> can Health advisor be configured with different threshold levels by

> dbspace?

>

>

>

>



>

>

>

>



--001a1147ef0230572a0514f9720b









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to admin-tools@iiug.org

2. Include the bracketed message number in the subject line: [3709]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Health advisor - can it ignore dbspaces
Posted by: bglidden1962@gmail.com (BILL GLIDDEN) - Wed, 29 Apr 2015 12:42:28 EDT
My health advisor always gives me red alarms on my plog and llog dbspaces. In

my case, they're both very static and I'm not worried that there is only 1%

free. Is there a way to have the Health advisor ignore specific dbspaces? Or,

can Health advisor be configured with different threshold levels by dbspace?









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to admin-tools@iiug.org

2. Include the bracketed message number in the subject line: [3708]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Utility for Browsing Ontape Backup Files
Posted by: bglidden1962@gmail.com (Bill Glidden) - Tue, 14 Apr 2015 16:41:22 EDT
Yes, you're right. I was just wondering if Pete was ambitious/brave enough

to deal with the logical logs :)



On Tue, Apr 14, 2015 at 2:49 PM, Art Kagel <art.kagel@gmail.com> wrote:



> Data in an archive file is AS OF the beginning of the archive, so there ARE

> NO changes to data in the archive files.

>

> Any changes made to the data after the AS OF time at the start of the

> archive will be captured by the logical logs and during a recovery will be

> rolled forward by applying the logical logs.

>

> Now, whether Pete's tool can manage to process logical logs is a different

> story.

>

> Art

>

> Art S. Kagel, President and Principal Consultant

> ASK Database Management

> www.askdbmgt.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 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 Tue, Apr 14, 2015 at 2:35 PM, Bill Glidden <bglidden1962@gmail.com>

> wrote:

>

> > Does your utility handle changes made to the table during the archive?

> >

> > On Tue, Apr 14, 2015 at 1:31 PM, PETE BROWN <jpb@chykn.com> wrote:

> >

> > > Received a few good questions & comments off list.

> > >

> > > 1. The utility is read-only. The idea is to provide a relatively quick

> > way

> > > to

> > > browse and export backup data without performing a restore. I don't

> plan

> > on

> > > adding features that will modify the backup files in any way.

> > >

> > > 2. It does not require an Informix instance or any other external

> > > dependencies. Just run the executable and use it to open your ontape

> > file.

> > >

> > > 3. So far it's been tested against backups from Linux based 10.0 and

> 11.5

> > > instances. I could definitely use some sample backup files from

> different

> > > platforms and versions for testing.

> > >

> > > 4. I'm working on this as a personal project, no corporate backing or

> > > anything. I release free (as in beer) utilities like this on occasion

> to

> > > make

> > > other engineers' lives a little easier.

> > >

> > > 5. I didn't put a download link in the original post because I normally

> > > prefer

> > > to have a few brave souls test it out first. Report back on any

> problems

> > > and

> > > provide initial feedback on the interface. Unfortunately the target

> > > audience

> > > for this one is limited, so here's the link for anyone else interested

> in

> > > testing.

> > >

> > > http://www.adhdtech.com/IFX%20Ontape%20Browser.exe

> > >

> > > At the moment I'm working on two items. Adding a pane so you can see

> > debug

> > > output from the parser and context menus so you can view the details

> for

> > > each

> > > object. Archive header info, table details, etc. Feedback is greatly

> > > appreciated.

> > >

> > >

> > >

> > >

> >

> >

>

>



> > >

> > >

> > >

> > >

> >

> > --001a11c30b4e6b22d60513b37e96

> >

> >

> >

> >

>

>



> >

> >

> >

> >

>

> --089e0122e6881529d90513b3aeda

>

>

>

>



>

>

>

>



--90e6ba614688b588120513b540f0









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to admin-tools@iiug.org

2. Include the bracketed message number in the subject line: [3707]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Utility for Browsing Ontape Backup Files
Posted by: art.kagel@gmail.com (Art Kagel) - Tue, 14 Apr 2015 15:14:21 EDT
The zip checks clean. Your self-extraction stub may be infected or, as you

say, it may have been a false positive.



Art



Art S. Kagel, President and Principal Consultant

ASK Database Management

www.askdbmgt.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 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 Tue, Apr 14, 2015 at 2:48 PM, PETE BROWN <jpb@chykn.com> wrote:



> Art,

> Thanks for the heads up. I'm not surprised that the EXE is flagged since

> it's

> not signed by a recognized software vendor. Here's a link to the same file

> in

> a ZIP...

>

> http://www.adhdtech.com/IFX%20Ontape%20Browser.zip

>

> Using archecker would definitely have been easier, but I'm working on a

> separate utility that requires backups to be read outside of a host loaded

> with Informix tools. An existing utility would have saved me a few months

> of

> staring at raw backup data like some giant jigsaw puzzle!

>

> Thanks,

> Pete

>

>

>

>



>

>

>

>



--001a11c2e33e8a18f70513b40936









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to admin-tools@iiug.org

2. Include the bracketed message number in the subject line: [3706]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Utility for Browsing Ontape Backup Files
Posted by: jpb@chykn.com (PETE BROWN) - Tue, 14 Apr 2015 15:03:20 EDT
Art,

Good point. No, the Ontape Browser does not apply the logical logs when

browsing data.



Thanks,

Pete









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to admin-tools@iiug.org

2. Include the bracketed message number in the subject line: [3705]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Art,

Good point. No, the Ontape Browser does not apply the logical logs when

browsing data.



Thanks,

Pete









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to admin-tools@iiug.org

2. Include the bracketed message number in the subject line: [3705]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

 
Subscribe to this feed
You can subscribe to this RSS feed in a number of ways, including the following:

Drag the orange RSS button into your News Reader

Drag the URL of the RSS feed into your News Reader

Cut and paste the URL of the RSS feed into your News Reader v