Informix International User Group - IDS Forum

Subscribe to Informix International User Group - IDS Forum feed Informix International User Group - IDS Forum
International Informix Users Group Forum: IDS Forum
Updated: 1 hour 5 min ago

More durable query

Fri, 15/03/2019 - 13:54
Hi,

Is there any way to see how is the more durable query in informix between
thousand of querys?. I mean, i want to know if one query is lasting for 5
minutes, other 3...and i can not enable any trace.

Regards.




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

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

1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [41553]

*******************************************************************************
Categories: Informix

Re: Informix 14.10 out

Thu, 14/03/2019 - 17:48
My mistake, HQ is version 1.1.0-SNAPSHOT according to the interface.
Stylistically, looks very similar to the last public version (.02).

John D. Ballentine III




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

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

1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [41552]

*******************************************************************************
Categories: Informix

Informix 14.10 out

Thu, 14/03/2019 - 16:51
Everyone -

I was looking for the latest version of OAT, and realized this morning that
the IBM Passport Advantage section has 14.10 Developer Edition available.
There is also now an Informix Edition Installer as a separate download -
appears to be a utility that you use to switch editions.

As expected, OAT is gone, and HQ is included instead. Note that it is
presented as version 0.1.0 during the install - still trying to get it
running, so not able to verify. It requires Java 8 as the minimum version.

John D. Ballentine III




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

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

1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [41551]

*******************************************************************************
Categories: Informix

LONG TRANSACTION issue solved

Wed, 13/03/2019 - 19:07
Thanks to a boost from Art, this problem is resolved.

I admit i should have realized it myself.

The answer is turn off logging in the sbspace: 'onspaces -ch <sbspace> -Df
"LOGGING=OFF"' . Then, after successful import, turn it back on.

The syntax issues that seem caused by something in the chain of myimport
processing doesn't quite recognize some comments contained in stored
procedures as comments. Apparently tries to parse them and produces an error.

Still working on those.

DG




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

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

1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [41550]

*******************************************************************************
Categories: Informix

Re: OAT latest

Wed, 13/03/2019 - 17:24
Just for my own clarification...

Am I misinformed, or maybe just mistaken or misremembering...

I thought that OAT has been thrown in the dust bin... Retired... Or
abandoned... Discontinued... Removed from life support.

Is that so?

DG




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

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

1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [41549]

*******************************************************************************
Categories: Informix

Re: One doubt

Wed, 13/03/2019 - 17:09
7.31 does support PSORT_NPROCS

From http://www.iiug.org/resources/faq/ifaq08.htm

8.29 How can I speed up sorts and index builds?

On 11th May 1998 kagel@bloomberg.com (Art S. Kagel) wrote:-

You have stumbled on a little known fact. Sorting is faster to filesystem
space than to temp table space. And since you do not care about the safety of
those sort-work files that's OK.

Even better still, for large sorts like index builds and UPDATE STATISTICS,
set the environment variable PSORT_DBTEMP to as many different filesystems as
possible (at least 3, keeping in mind that the smallest will limit the size of
the sort that is possible). Also, contrary to the documentation, setting
PSORT_NPROCS to a value between 20 and 40 will also speed the sorting as long
as you can afford to allocate so many resources to that one task. You might
see the time drop to 15 or 20 minutes.




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

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

1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [41548]

*******************************************************************************
Categories: Informix

Re: OAT latest

Wed, 13/03/2019 - 08:24
Hi Mark.

It was last provided with IDS 12.10.xC9 (or CSDK 4.10.FC9) for Linux or
Windows which is still on Fix Central.

Regards,
Doug




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

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

1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [41547]

*******************************************************************************
Categories: Informix

Re: myimport Problem

Wed, 13/03/2019 - 00:32
Recap: The two errors originally at the top of the stderr output from myimport
are now gone, after making sure that the gnu versions of sed and awk were
being used. I am still working on several remaining syntax errors that appear
to derive from comments in the SPLs that are not accurately recognized as
comments.

Anyway, Now that it appears that all the tables are actually (attempting to
be) imported, I am starting a separate, parallel effort to try to fix one or
two remaining problems with table data imports. I am running into a LONG
TRANSACTION error with one of the tables. I have used the "-n nolog" flag to
eliminate logging, but, this particular table has a column that is a smart
large object (a photo). Creation of smart large objects is always logged and
that logging can't be disabled (so far as I know). There are several 100K rows
in that table, and the it gets, maybe, 40% loaded before the LONG TRANSACTION
abort.

Any suggestions on how I can 'myimport' the data into that table?

Thank you.

DG




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

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

1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [41546]

*******************************************************************************
Categories: Informix

Re: rootdbs full

Tue, 12/03/2019 - 22:19
I agree with Mr. Lawry ... use shrink on the dbspace or better yet, since it's
the rootdbs, shrink the tables in sysmaster.

Thanks -
Mark Scranton
The Mark Scranton Group




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

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

1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [41545]

*******************************************************************************
Categories: Informix

Re: Maximum of 16,777,215 pages per Table

Tue, 12/03/2019 - 22:17
If you chose REPACK, you'll most likely need to add disk to that dbspace
otherwise the repack will fail since it has no "working storage" (for us COBOL
folks) to work in.

Thanks -
Mark Scranton
The Mark Scranton Group




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

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

1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [41544]

*******************************************************************************
Categories: Informix

Re: EXTERNAL TABLE issue?

Tue, 12/03/2019 - 22:16
I too have been using external tables (we from the XPS world call it the
ploader) and under 12.10.FC10 I'm seeing errors that never occurred prior.
Really, really irritating. I'll open a PMR though now that I see others have
had similar issues.

Thanks -
Mark Scranton
The Mark Scranton Group




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

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

1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [41543]

*******************************************************************************
Categories: Informix

OAT latest

Tue, 12/03/2019 - 22:12
Does anyone have a link to or copy of the latest OAT?

Thanks -
Mark Scranton
The Mark Scranton Group




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

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

1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [41542]

*******************************************************************************
Categories: Informix

Re: INH mutex

Mon, 11/03/2019 - 13:26
Just to update the group and anyone looking at this issue at a later date, I
raised a case with support and a defect has been raised: idsdb00098913

To see the issue, you'll need a high load with a large number of threads plus
a schema with several levels of table dependencies (via foreign keys).

Ben.




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

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

1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [41541]

*******************************************************************************
Categories: Informix

Re: Some Progress running "myimport"

Sat, 09/03/2019 - 01:53
(See my immediately previous post)

Changing the 'myimport' script to eliminate the hardwired reference to "awk",
eliminated the awk errors I described earlier.

Now, the only errors that remain are syntax errors during the execution of
myimport. That is, the result of running myexport produces files that result
in syntax errors when executing myimport to attempt to import the database
just exported.

I need to investigate this further, but after a very quick look, it seems that
there may be issues with statements in SPLs that are commented out, but
somehow generating syntax errors during the import.

I'll continue to check this out, as I have time.

DG

P.S. In the past, using the official dbimport and dbexport, i have also
encountered situations in which dbimport cannot import the product of
dbexport. I first encountered this about 15 years ago, and have always
wondered why IBM didn't fix it.




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

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

1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [41540]

*******************************************************************************
Categories: Informix

Re: Some Progress running "myimport"

Sat, 09/03/2019 - 01:33
Thank you for the suggestion.

I examined the "myimport" script, and observed that there was some code to
determine what version of awk was available, and the result of this was used
to set an environment variable that was then used later to actually invoke
awk. Except that it appeared that there was one other invocation of awk that
had "awk", instead of the script variable, hardwired into the script (thus
invoking the Solaris /usr/bin/awk which is in the PATH).

I don't know if changing that reference so that it will use the GNU awk will
help or not, but I am trying it.

DG




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

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

1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [41539]

*******************************************************************************
Categories: Informix

Re: SET GLOBAL Variable in SQL Select?

Thu, 07/03/2019 - 14:41
Hi.
According to the official docs, global variables are only available for SPL
code.


https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.sqlt.doc/ids_sqt_450.htm

HTH
Best regards
Alexandre Marini




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

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

1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [41538]

*******************************************************************************
Categories: Informix

SET GLOBAL Variable in SQL Select?

Wed, 06/03/2019 - 18:22
Hello,

All of the examples I can find show how to set a global variable inside SPL
functions.

Can values be assigned to global variables from within a dynamic SQL
statement?

I'm using Server Studio and have tried SET/LET but all I get is syntax errors.

Thanks.




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

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

1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [41537]

*******************************************************************************
Categories: Informix

Re: Some Progress running "myimport"

Wed, 06/03/2019 - 07:00
In relation to the awk errors, could it be the same issue you had with sed?
Expecting gnu awk, but using Solaris awk ?

Luis Marques




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

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

1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [41536]

*******************************************************************************
Categories: Informix

Some Progress running "myimport"

Wed, 06/03/2019 - 00:36
I concluded that the 3rd line of the error messages from myimport's stderr,
"sed: illegal option -- r" came from the Solaris version of sed, and that
"myimport" must need the GNU version. So, I edited the "myimport" script to
refer to "gsed", instead of "sed".

That eliminated the "sed" error message. But, the first two lines of error
messages:

awk: syntax error near line 33
awk: bailing out near line 33

remain. Now, when I run 'myimport -E -l nolog -i <path/to/the/.exp> <db>',
all the error messages about nonexistent tables go away.

These are the ones that disappeared:
206: The specified table (acct_hld_cd) is not in the database.
111: ISAM error: no record found.

Now, most of the stored procedures seem to import. But, not all. A few
generate syntax error messages. This I don't understand, since the source is
the schema file generated by myexport.

Also, some of the tables now import, but, some do not. All of them are
properly defined in the database, but some have their data, and some do not
(zero rows).

I wonder how much of this derives from the awk error messages at the top of
this post. What awk file do these error messages refer to? "myimport" itself?
"from_external.awk"? Something else I am completely missing?

I think I'm still a long way from having 'myimport' just work. The potential
speed advantage of getting this to work is very valuable. But, it just doesn't
seem to be happening.

DG




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

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

1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [41535]

*******************************************************************************
Categories: Informix

One doubt

Tue, 05/03/2019 - 23:34
In Informix IDS 7.31 for Windows, the PSORT_NPROCS environment variable not
exists or not works?

Thanks in advance




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

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

1. Address it to ids@iiug.org
2. Include the bracketed message number in the subject line: [41534]

*******************************************************************************
Categories: Informix

Pages