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 31 min ago

Windows server informix perfomance 12.X vs 11.X

Sun, 19/05/2019 - 19:31
Hello,

i have a strange behaviour, maybe somebody can help.

Short:

Windows Server 2008R2 x64bit with 2 Informix installations.
Installation are "default" no changes on parameter.

One Installation Informix 11.7, the other 12.10.
Created "demonstration database" for 11.7 and 12.10 server instance.

For the 11.7 the installed OAT shows good storage wait times.
For the 12.10 the installed OAT shows BAD storage wait times.

Background: in production system database on our 11.7 seems to have better
performance than on new 12.10 server.
Also on production server we can see the difference in OAT.
So we installed a test system.

At the moment we can not find the problem.
For the test system both informix installations are running on same server,
configuration is default from installation, same filesystem, database files on
same harddisk.

On a linux system (also installed default) with informix 12.10 the OAT shows
good waittimes.

Maybe somebody have seen similar behaviuor on other systems?

We have talked with our people running informix 12.X on windows server, they
have good performance and wait times.

Regards

Marc




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

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: [41707]

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

Re: Change to Forum email submissions

Wed, 15/05/2019 - 22:50
I hope the new email platform arrives sooner than later. I get very few
messages via it now, and strangely ones I have had lately were not to be found
in the online forum pages. I did see mention of some whatsapp groups that
stuff had moved to (or was it mirrored to, or set up in parallel with?), but I
stay clear of facebook related products. So I've felt very disconnected for
around a year or so now.
-Bryce.




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

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: [41706]

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

Re: 4gl not ending FOR loop thru file for IDS ver

Wed, 15/05/2019 - 19:37
From IBM:

I presented this issue to Informix Development and you are correct, there is a
change in behaviour since 7.50.xC4.
Below is our analysis with another workaround at the end. Let me know what you
think.

Regards,

--XXX

We did a quick test on a Linux box and see a difference between old and new:

informix@irk:/tmp$ cat open.4gl

database sysmaster

DEFINE f_file_name varchar(20),

f_mail_add varchar(255),

f_subj_line varchar(255),

m_mail_path varchar(255),

f_cmd varchar(255) ,

f_file int,

f_i int

main

let f_file_name="./open.txt"

let f_subj_line="4glemail"

let m_mail_path="testpath"

OPEN FILE f_file FROM f_file_name OPTIONS (READ, FORMAT = "text")

FOR f_i = 1 TO 10

display f_mail_add

READ FROM f_file INTO f_mail_add

display f_mail_add

IF f_mail_add IS NULL THEN

EXIT FOR

END IF

LET f_cmd = "mail -s \"", f_subj_line CLIPPED,"\""," ", f_mail_add CLIPPED ,"<
", m_mail_path CLIPPED

LET f_cmd = f_cmd CLIPPED

display f_cmd

run f_cmd

#CALL run_system_cmd(f_cmd)

END FOR

CLOSE FILE f_file

end main

informix@irk:/tmp$ cat open.txt

line 1

line 2

line 3

informix@irk:/tmp$

With 7.50.FC5:

informix@irk:/tmp$ c4gl -V

IBM INFORMIX-4GL Version 7.50.FC5

Software Serial Number RDS#N000000

informix@irk:/tmp$ c4gl open.4gl

informix@irk:/tmp$ ./a.out

line 1

mail -s "4glemail" line 1< root@test.com

bash: root@test.com: No such file or directory

line 1

line 2

mail -s "4glemail" line 2< root@test.com

bash: root@test.com: No such file or directory

line 2

line 3

mail -s "4glemail" line 3< root@test.com

bash: root@test.com: No such file or directory

line 3

informix@irk:/tmp$

With 7.51.FC2:

informix@irk:/tmp$ c4gl -V

IBM INFORMIX-4GL Version 7.51.FC2

Software Serial Number RDS#N000000

informix@irk:/tmp$ c4gl open.4gl

informix@irk:/tmp$ ./a.out

line 1

mail -s "4glemail" line 1< root@test.com

bash: root@test.com: No such file or directory

line 1

line 2

mail -s "4glemail" line 2< root@test.com

bash: root@test.com: No such file or directory

line 2

line 3

mail -s "4glemail" line 3< root@test.com

bash: root@test.com: No such file or directory

line 3

line 3

mail -s "4glemail" line 3< root@test.com

bash: root@test.com: No such file or directory

line 3

line 3

mail -s "4glemail" line 3< root@test.com

bash: root@test.com: No such file or directory

line 3

line 3

mail -s "4glemail" line 3< root@test.com

bash: root@test.com: No such file or directory

line 3

line 3

mail -s "4glemail" line 3< root@test.com

bash: root@test.com: No such file or directory

line 3

line 3

mail -s "4glemail" line 3< root@test.com

bash: root@test.com: No such file or directory

line 3

line 3

mail -s "4glemail" line 3< root@test.com

bash: root@test.com: No such file or directory

line 3

line 3

mail -s "4glemail" line 3< root@test.com

bash: root@test.com: No such file or directory

informix@irk:/tmp$

7.51 needs an empty new line at the end of the file, otherwise the variable
will not be NULL and it will not exit the loop (repeting the last line)
I think that why CLIPPED internally works on 7.50.

Having a new line it will exit the loop:

informix@irk:/tmp$ cat open.txt

line 1

line 2

line 3

informix@irk:/tmp$ ./a.out

line 1

mail -s "4glemail" line 1< root@test.com

bash: root@test.com: No such file or directory

line 1

line 2

mail -s "4glemail" line 2< root@test.com

bash: root@test.com: No such file or directory

line 2

line 3

mail -s "4glemail" line 3< root@test.com

bash: root@test.com: No such file or directory

line 3

informix@irk:/tmp$

Another option is to NULL the variable before it does the next iteraction:

.....

display f_cmd

run f_cmd

#CALL run_system_cmd(f_cmd)

LET f_mail_add = NULL

END FOR

CLOSE FILE f_file




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

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: [41705]

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

Re: prevent automatic generation of sbspace

Wed, 15/05/2019 - 18:26
Hi Art,
bevor my posting I renamed the bts.3.11 directory to no_bts...
the sbspace was generated anyway, but the blademgr worked.
If I rename the extend-directory, the sbspace will be created but the blademgr
gives an error when 'list <database>'.

Renaming the directories prevents registering the bts module but not creating
the sbspace.
That's not what I want.




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

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: [41704]

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

Re: prevent automatic generation of sbspace

Wed, 15/05/2019 - 16:51
Rename the 'extend' subdirectory under $INFORMIXDIR or rename those blade
subdirectories under 'extend' that you do not want to be installable. Then the
auto-registration will not work.




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

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: [41703]

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

Re: 4gl not ending FOR loop thru file for IDS ....

Wed, 15/05/2019 - 14:12
Update from IBM:

14 May 2019 3:24 PM

I'm wondering if it's related to this defect which was fixed in 4GL 7.51.xC1:

APAR IC93179 - 4GL: BEHAVIOR OF CLIPPED HAS CHANGED FROM VERSION 7.32 TO 7.50

Error Description

----------------------------------------------------------------------------------
In version 7.32.xxx of IBM Informix 4GL, CLIPPED removed only
trailing spaces. In version 7.50.xxx of IBM Informix 4GL,
CLIPPED also removes the line feed character.

We are using: IBM INFORMIX-4GL Version 7.51.FC2, which still seem to be an
issue with the use of CLIPPED.




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

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: [41702]

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

Re: Need some help with INFORMIX/IREACH

Wed, 15/05/2019 - 13:57
Juan:

There is nothing wrong with that query and REMOTE_USER looks like a local host
variable generated by the application.




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

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: [41701]

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

Change to Forum email submissions

Wed, 15/05/2019 - 11:55
Folks:

The IIUG Board of Directors has moved out email service to a new platform. As
a consequence you will no longer be able to submit Forum posts and responses
to Forum posts via email and will have to use the web interface.

Note that the Board is working with IBM to replace these forums with a modern
Forum and Blog site for the Informix community hosted by IBM. The new forums
will be available for use shortly.




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

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: [41700]

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

New IIUG Software Repository

Wed, 15/05/2019 - 11:43
The IIUG Software Repository has been moved to Softforge. You can navigate
there from the IIUG main page <Resources> menu or use this direct link:

http://www.iiug.org/en/iiug-software-repository/

Art




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

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: [41699]

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

4gl not ending FOR loop thru file for IDS ver 12.1

Tue, 14/05/2019 - 18:10
Question, we are using a 4gl program code that reads a file, which contains
email addresses. In IDS 11.50, we do not have to add a blank line at the
bottom of the list file. We are having to add a blank line to the bottom of
the list file while using IDS ver 12.10. Otherwise the FOR loop continues 1000
times.

Has anyone experienced this issue for resolution?

IDS: IBM Informix Dynamic Server Version 12.10.FC10

OS: AIX 7.2

4GL / ISQL: 7.51.FC2

CSDK / ESQL: 4.10.FC10

CODE:

ok - this is the commands that send the email:

LET f_cmd = "test -f ", f_file_name

RUN f_cmd RETURNING f_result

IF NOT f_result THEN --File found

OPEN FILE f_file FROM f_file_name OPTIONS (READ, FORMAT = "text")

FOR f_i = 1 TO 1000

READ FROM f_file INTO f_mail_add

IF f_mail_add IS NULL THEN

EXIT FOR

END IF

LET f_cmd = "mail -s \"", f_subj_line CLIPPED,"\""," ", f_mail_add CLIPPED ,"<
", m_mail_path CLIPPED

LET f_cmd = f_cmd CLIPPED

CALL run_system_cmd(f_cmd)

END FOR

CLOSE FILE f_file

END IF




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

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: [41698]

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

Need some help with INFORMIX/IREACH

Mon, 13/05/2019 - 12:37
Hello everybody,
I known it is very long time since Ireach is not supported by IBM any more,
but still there ara some customers who use it, and one of these is mine.
I am looking for somebody who can help me in solving the following issue:

This is the message:

Error Code: -937
Error state: UWEB1
Error Message: Undefined variable:$session.REMOTE_USER
SQL sentence: SELECT height, width, description, object, (select super_type ||
'/' || sub_type from wbextensions where wbbinaries.extension =
wbextensions.extension ) FROM wbbinaries WHERE ID = 'iconSearch';

Please let me know if you requiere more information.

Kind 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: [41697]

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

Re: prevent automatic generation of sbspace

Fri, 10/05/2019 - 13:21
Did a couple of tests, could not stop Informix from auto registering the bts
blade and create a sbspace, even with an unprivileged user. The behavior is
described in "What's new in DataBlade module installation and registration for
Informix, Version 11.70":


https://www.ibm.com/support/knowledgecenter/en/SSGU8G_11.70.0/com.ibm.dmir.doc/ids_dmir_069.htm

Best option is to open a support request with IBM.
One possible mitigation would be to create a small sbspace so the automatic
blade registration makes use of it, instead of auto creating it outside of the
DBA control.




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

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: [41696]

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

Re: prevent automatic generation of sbspace

Thu, 09/05/2019 - 17:13
Please,
or tell me if there is no chance to prevent this.
Ruediger




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

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: [41695]

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

prevent automatic generation of sbspace

Thu, 09/05/2019 - 10:58
How can I prevent automatic generation of SBSPACE and automatic registration
of BTS-Modul ?
IDS 12.10.FC12
My Instance has no SBSPACE and no datablade is registered in any database.
If a 'normal' user with connect right runs (can be accidental) a SQL-Statement
like 'SELECT xxx FROM yyy WHERE bts_contains (lname,'Taylor') then
automatically a sbspace is created, registered in ONCONFIG, and BTS-Modul is
registered in database.
How can this be prevented?
I don't want a creation of a dbspace or a registration of a datablade due to a
user error.
TIA
Ruediger




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

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: [41694]

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

Re: Connections over SSL

Wed, 08/05/2019 - 15:26
Yes, on the server side, according to the documentation, the keystore file
must have the name DBSERVERNAME.kdb and be created in $INFORMIXDIR/ssl/ .
On the client side, the name and location can be defined in the
$INFORMIXDIR/conssl.cfg using the parameters SSL_KEYSTORE_FILE and
SSL_KEYSTORE_STH .




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

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: [41693]

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

Re: Connections over SSL

Wed, 08/05/2019 - 14:55
Thanks for the reply,

My mistake was that I have used one alias for argument on gsk8capicmd for -db.
It seems to be necessary that argument is the same as DBSERVERNAME.

SP




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

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: [41692]

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

Re: dbexport/dbimport question

Tue, 07/05/2019 - 20:42
I am going to try reworking the dbspace layout of our databases, on a test
server. I'm thinking that, if each database is in its own set of dbspaces and
sbspaces, maybe we can use ontape to backup individual databases.

Up to now, we have been using the S.A.M.E. strategy that Oracle advanced and
advocated a long time (maybe 15 years ago???). Because of the extreme
simplicitly of administering that kind of space layout, we have near zero time
required for space layout architecture issues. It worked for us. But, maybe
it's time for a change, and maybe we can get what we want by doing this (and
stay with Informix, which has great advantage in stability and low DBA time
demands).

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: [41691]

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

Re: dbexport/dbimport question

Tue, 07/05/2019 - 20:25
We want to back up a complete database. The catalog and all the tables and
stored procedures. We want to be able to restore it on another machine (same
configuration). We want it to function as quickly and as consistently as
invisible-to-the-user as ontape.

In the past, we used to use onunload. But, that is no longer possible because
onunload does not function when Informix is used as intended (e.g., with smart
large objects).

If onunload worked when a database contained smart large objects (a feature of
Informix for a decade or two), we could do what we need to do much more easily
than we do now. It would be even better if onunload could work like ontape,
and provide a consistent archive without taking the database down (or needing
to lock it).

I know. This is impossible for Informix.

Things like this. And other errors (such as an error in execution of legal
SQL-- which lead to an APAR-- on the very first day that a new developer
started) make it increasingly difficult to ignore in-house calls to explore
other options. We just need some basic conveniences and functionality that
seem to be unavailable in Informix. I say this with a heavy heart, after
working with Informix for more than 20 years.

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: [41690]

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

Re: configure sds with raw device

Tue, 07/05/2019 - 01:23
Hello Eric. Thank you for your interest.

As I mentioned in the previous article, the storage used by Informix consists
of raw devices.

So I had to switch the logical volumes into enhanced concurrent mode with the
varyon command to make them accessible from two hosts.

I do not want to use HA Cluster software when configuring SDS whenever
possible, but according to the IBM Knowledge Center article, PowerHA (formerly
HACMP) is required to set up concurrent logical volumes.

If you are using a file system such as GPFS, HACMP may not be needed. However,
I can not test it because I do not have a GPFS license. And I know GPFS is
more expensive than HACMP.

In addition, the steps below show how to set up a concurrent volume group
without HA Cluster. I have not tried the methods below yet.
https://www-01.ibm.com/support/docview.wss?uid=isg3T1024417




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

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: [41689]

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

Re: Revised Final Answer: EXTERNAL TABLE issue

Mon, 06/05/2019 - 17:09
Thank you for your comment, Mr. Vercelleto.

I did actually ask for the APAR at the time we were actively working the case.
But, the engineer told me it was not available for public release at that
time.

(I haven't contacted tech support again, concerning this issue.)

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: [41688]

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

Pages