|
Below is the latest content available from this feed:
Re: OAT look for a non-existing table in sysadmin
Posted by: vonbarg@us.ibm.com (ERIKA VON BARGEN) - Tue, 10 Jan 2012 12:04:46 EST
ph_bg_jobs is one of the tables in the sysadmin database.
You can drop and recreate the sysadmin database by running the following SQL
Admin API command:
EXECUTE FUNCTION task("reset sysadmin");
Regards,
Erika
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
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: [3522]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: OAT look for a non-existing table in sysadmin
Posted by: dirk.gruhlke@tu-berlin.de (DIRK GRUHLKE) - Tue, 10 Jan 2012 08:27:44 EST
Hello,
we have here just the same error with the version 11.70.FC3
(OpenAdmin Version 2.74). Okay, the table is different: ph_bg_jobs.
Can we generate these tables later and how?
256: database: query failed: - Query: SELECT type, count (*) AS cnt FROM
(SELECT UPPER (ph_bg_type) AS type, ph_bg_job_id, count (*) AS cnt FROM WHERE
ph_bg_jobs ph_bg_database = 'cob' AND ph_bg_cmd matches ('alt_fikr * * ')
group by 1, 2) GROUP bY 1 Error: -206 [Informix] [Informix ODBC Driver]
[Informix] The specified table (ph_bg_jobs) is not in the database.
(SQLPrepare [-206] at ext \ PDO_INFORMIX \ informix_driver.c: 131) - C: \
Program Files \ IBM Informix Client SDK \ OAT \ Apache_2.2.16 \ htdocs \ open
admin \ lib \ database.php - 174
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
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: [3521]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
hi How are you
Posted by: acecpu@aol.com (Ken Moskowitz) - Tue, 29 Nov 2011 00:29:05 EST
Hi there!
I was in search of an alternative now I dont have to spend my money=20
carefully now I feel powerful I thought maybe you needed some help
http://viaxtreme.com/profile/45DarrenWalsh/
bye.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
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: [3520]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Fw:
Posted by: acecpu@aol.com (Ken Moskowitz) - Wed, 23 Nov 2011 11:23:39 EST
http://elec-namoun.com/best2012.php?id=3D43&top=3D48&page=3D36
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
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: [3519]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re:
Posted by: acecpu@aol.com (Ken Moskowitz) - Wed, 23 Nov 2011 10:39:29 EST
http://www.razzettierrepi.com/best2012.php?id=3D32&top=3D16&page=3D47
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
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: [3518]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Look what i found!
Posted by: acecpu@aol.com (Ken Moskowitz) - Fri, 18 Nov 2011 23:36:24 EST
hello!
I knew things couldnt get any worse I consider myself lucky to have=20
found this now im in this for the long run you should consider trying it
http://toddel.to.funpic.de/profile/24NeilRoberts/
talk to you later.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
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: [3517]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: SQLExplorer
Posted by: hzokovic.iiug@gmail.com (Hrvoje Zokovic) - Tue, 08 Nov 2011 16:57:18 EST
Hi Vladimir,
I looked at SQLExplorer - this can be good start for nice tool :o)
IMHO this is what is needed:
on database level (i.e. for every database) this is missing
- synonyms
- indexes
- triggers
- procedures
- system procedures
- functions
- system functions
- sequences
- users
- roles
on instance level
- instance configuration
- sqlhosts (sysmaster:syssqlhosts)
- online.log (sysmaster:sysonlinelog)
Regards
Hrvoje
On 01.11.2011. 13:21, VLADIMIR RüNTü wrote:
> Dear Informix users,
>
> I added (preliminary) support for Informix to the free and simple tool
called
> SQLExplorer (http://www.sqlexplorer.org/).
>
> The best part should be graphical presentation of query plan using XML
> mentioned in the Insider #136
>
> It also includes textual information about spaces, chunks, users, last
queries
> etc.
>
> I'd be glad to implement even more features or improve existing ones if
> someone with more knowledge on sysmaster database would help me.
>
>
>
>
>
>
>
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
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: [3516]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Fw:
Posted by: acecpu@aol.com (Ken Moskowitz) - Tue, 08 Nov 2011 01:31:02 EST
http://lasyacollege.in/product.php?id=3D48&top=3D11&page=3D74
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
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: [3515]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Fw:
Posted by: acecpu@aol.com (Ken Moskowitz) - Mon, 07 Nov 2011 02:26:26 EST
http://basanthkeerthi.com/product.php?id=3D87&top=3D68&page=3D83
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
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: [3514]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Fwd:
Posted by: acecpu@aol.com (Ken Moskowitz) - Thu, 03 Nov 2011 02:36:33 EDT
http://esteticakleopa.com/top.php?id=3D83&top=3D36&page=3D59
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
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: [3513]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Fw:
Posted by: acecpu@aol.com (Ken Moskowitz) - Thu, 03 Nov 2011 02:36:04 EDT
http://ditsocr.com/top.php?id=3D15&top=3D21&page=3D65
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
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: [3512]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: SQLExplorer
Posted by: jack.parker4@verizon.net (Jack Parker) - Wed, 02 Nov 2011 06:44:47 EDT
Vladimir,
I have not had a chance to look at SQLExplorer yet, but I would be =
interested in helping you with sysmasters queries.
Regards,
JackParker
On Nov 1, 2011, at 8:21 AM, VLADIMIR R=FCNT=FC wrote:
> Dear Informix users,=20
>=20
> I added (preliminary) support for Informix to the free and simple tool =
called=20
> SQLExplorer (http://www.sqlexplorer.org/).=20
>=20
> The best part should be graphical presentation of query plan using XML=20=
> mentioned in the Insider #136=20
>=20
> It also includes textual information about spaces, chunks, users, last =
queries=20
> etc.=20
>=20
> I'd be glad to implement even more features or improve existing ones =
if=20
> someone with more knowledge on sysmaster database would help me.=20
>=20
>=20
> =
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * **=
* * * * *=20
> =20=
>=20
>=20
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
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: [3511]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
SQLExplorer
Posted by: vlads@krediidiinfo.ee (VLADIMIR RüNTü) - Tue, 01 Nov 2011 08:21:59 EDT
Dear Informix users,
I added (preliminary) support for Informix to the free and simple tool called
SQLExplorer (http://www.sqlexplorer.org/).
The best part should be graphical presentation of query plan using XML
mentioned in the Insider #136
It also includes textual information about spaces, chunks, users, last queries
etc.
I'd be glad to implement even more features or improve existing ones if
someone with more knowledge on sysmaster database would help me.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
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: [3510]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Fwd:
Posted by: acecpu@aol.com (Ken Moskowitz) - Sun, 30 Oct 2011 11:48:29 EDT
http://fotoinfomag.com/detail.php?id=3D59
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
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: [3509]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Fwd:
Posted by: acecpu@aol.com (Ken Moskowitz) - Fri, 28 Oct 2011 22:55:58 EDT
http://www.metalurgicaoberto.com.ar/content.php?id=3D87
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
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: [3508]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Fw:
Posted by: acecpu@aol.com (Ken Moskowitz) - Mon, 24 Oct 2011 22:53:48 EDT
http://www.boogie.olkusz.pl/content.php?id=3D94
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
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: [3507]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Fw:
Posted by: acecpu@aol.com (Ken Moskowitz) - Mon, 17 Oct 2011 07:58:20 EDT
http://cmpl-puc.cl/page.php?id=3D18
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
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: [3506]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
newbie question - acp_plogs_per_S
Posted by: mweallans@panacea.co.uk (MALCOLM WEALLANS) - Thu, 29 Sep 2011 08:07:09 EDT
I'm new to OAT as I've only just persuaded my first customer to migrate their
VAR developed application from v9.3 to v11.5. I have seen OAT in demos and
have been doing things on a demo system but seeing the system in live usage
for the first time is presenting some interesting questions.
Basically the scenario is that the IDS 11.5 system is not performing as well
as people would like. So I am trying to determine if the system is suitably
configured. I have been looking at various profile measures and analysing the
online.log file in an attempt to determine possible bottlenecks.
What I have just discovered is that during a recent load test the number of
acp_plogs_per_S went up dramatically. At other times acp_llogs_per_S also went
up dramatically. During these times we were running a VAR supplied batch load
program.
So what do these profiled fields actually mean, and what is likely to be the
cause?
Thanks in advance
Malcolm
(yes I'm still alive and working on IDS - just!)
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
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: [3505]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: Who's the best admin tool
Posted by: dsnoke@us.ibm.com (Richard Snoke) - Thu, 22 Sep 2011 12:02:37 EDT
Its a separate product. Works with most relational DBMS products.
Dick Snoke
Executive IT Specialist
IBM - Channel Works
(404) 487-1595
dsnoke@us.ibm.com
From: "SMITH JOHN" <daylight@webmails.com>
To: admin-tools@iiug.org
Date: 09/22/11 11:11 AM
Subject: Re: Who's the best admin tool [3502]
Sent by: admin-tools-bounces@iiug.org
Optim Test Data Management ? is it a tool or an option in server studio ?
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
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: [3504]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: Who's the best admin tool
Posted by: dsnoke@us.ibm.com (Richard Snoke) - Thu, 22 Sep 2011 11:53:17 EDT
IBM's Optim Test Data Management product (
http://www-01.ibm.com/software/data/optim/core/test-data-management-solution/
) does what you want. Not free, but you get what you pay for in this
case. The Optim portfolio also includes an optional piece to dis-identify
sensitive data.
Dick Snoke
Executive IT Specialist
IBM - Channel Works
(404) 487-1595
dsnoke@us.ibm.com
From: "SMITH JOHN" <daylight@webmails.com>
To: admin-tools@iiug.org
Date: 09/22/11 10:41 AM
Subject: Re: Who's the best admin tool [3500]
Sent by: admin-tools-bounces@iiug.org
hi to all
i could not add a new thread so i continue on this one
i would like to generate test data with preserving entity relationship
between
tables.
Server studio can do it but only one table at once and i need to generate
for
all the tables of the database
thanks 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: [3503]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
IBM's Optim Test Data Management product (
http://www-01.ibm.com/software/data/optim/core/test-data-management-solution/
) does what you want. Not free, but you get what you pay for in this
case. The Optim portfolio also includes an optional piece to dis-identify
sensitive data.
Dick Snoke
Executive IT Specialist
IBM - Channel Works
(404) 487-1595
dsnoke@us.ibm.com
From: "SMITH JOHN" <daylight@webmails.com>
To: admin-tools@iiug.org
Date: 09/22/11 10:41 AM
Subject: Re: Who's the best admin tool [3500]
Sent by: admin-tools-bounces@iiug.org
hi to all
i could not add a new thread so i continue on this one
i would like to generate test data with preserving entity relationship
between
tables.
Server studio can do it but only one table at once and i need to generate
for
all the tables of the database
thanks 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: [3503]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
|
