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

Re: Connection Managers not forwarding connections

Sat, 19/01/2019 - 01:30
Correction, DB version is 12.10FC11




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

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

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

Re: Connection Managers not forwarding connections

Sat, 19/01/2019 - 01:18
There was an OS/bios upgrade not informix




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

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

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

Connection Managers not forwarding connections

Sat, 19/01/2019 - 01:13
Hi,
We had an upgrade for the whole informix cluster and after bringing up all the
servers , couldn't resync HDR with primary because it was always causing
checkpoint blocked on the primary. Afterwards, I noticed that the connection
managers aren't forwarding traffic, restarted them multiple times, upgraded
csdk to the last version 12.10 FC12, but nothing changed.
Connection manager log says it connected successfully to primary server and on
primary server onstat -g cmsm says that connection manager is connected, also
reporting in online.log. I am able to connect directly to the database but i'm
not able to connect to the database through connection manager.
On tcpdump, there is traffic between connection manager and primary and on
connection manager we can see the traffic from the clients, but nothing
reaches the database also there are no writes in the connection manager log
It is possible that the connection manager is not sending traffic because HDR
is not paired with primary and can't connect to it ?

informix db version in 12.10 FC9 and CM version is 12.10 FC12




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

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

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

Fastest export/import?

Fri, 18/01/2019 - 19:20
Informix 12.10.FC12
Solaris 10 1/2013

I have been searching back posts, and I think I understand that the absolute
fastest export/import is achieved by using Art's myexport and myimport with -E
option (external tables). So, neither sqlcmd nor myonpload is necessary for
this specific objective of achieving fastest export/import.

For example:
myexport <my_database> -E -m -p
myimport <my_database> -E -m -U -p

Do I understand correctly?

I welcome being set straight if I am misunderstanding.

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

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

Re: Windows User Authentication

Fri, 18/01/2019 - 13:29
Nobody here who could answer my question?




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

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

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

Re: Error -243 ISAM -154 with Select sentence

Wed, 09/01/2019 - 23:23
Thanks Jacques.

You're right.
We were monitoring the program and effectively the isolation level is comitted
read. Investigating we realize that the main program uses esql functions that
are in an external library. One of these functions executes the command "set
isolation to committed read" with which it overrride the initial setting
(dirty read) of the program.

Best 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: [41449]

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

Re: Unused space inside a Table

Wed, 09/01/2019 - 09:00
Awesome. Thank you.

As I expected.

:-)
Thanks again




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

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

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

Re: Unused space inside a Table

Tue, 08/01/2019 - 13:55
I believe it will fill up the allocated extents first "at the end of the
table". When it gets to the end of the extents currently allocated, the engine
will scan the table's bitmap pages from the beginning looking for empty or
partially full pages and use these up before a new extent is allocated.

There is a slight complication in with tables with variable width columns
(usually varchars) whereby a partially full page may have space for a shorter
row and not a longer one. If the row is too long to fit, the engine will
continue to scan the bitmap pages.

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

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

Unused space inside a Table

Tue, 08/01/2019 - 08:34
When you delete records from a Table, the empty space is not released /
free'ed up.

My question is:

If you now insert records again, will the unused space be used first, to add
the new records, or will it be added "at the end of the table" (for lack of
better words), and new extents be added (the table will still grow) ?

IDS 12
AIX 7




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

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

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

Re: Informix csdk download?

Mon, 07/01/2019 - 14:59
Benjamin,

Great! Thank you so much. I was able to download it. Thank you for the
comprehensive response.

--Dave




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

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

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

Reading logical logs of informix

Mon, 07/01/2019 - 02:19
Is it possible to find what was being written in database at a certain point
of time by reading logical-logs?




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

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

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

Re: Error -243 ISAM -154 with Select sentence

Fri, 04/01/2019 - 22:06
Thanks Doug,

But according to the article:


http://informix-technology.blogspot.com/2006/10/when-exclusive-is-not-really-exclusive.html

"When you set the exclusive lock on a table using "BEGIN WORK; LOCK TABLE IN
EXCLUSIVE MODE you don't prevent sessions with DIRTY READ isolation level from
accessing the table"

I've made a little laboratory, and that's certainly true.




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

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

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

Re: Error -243 ISAM -154 with Select sentence

Fri, 04/01/2019 - 18:50
Original post:

Hi,
We have a program esql/c that has the following sentences:

set isolation to dirty read;
set lock mode to wait 30;

The program makes several select, update and insert operations

Recently these error messages came out when executing a select statement:

error -243 (Could not position within a table) ISAM -154 (Lock Timeout
Expired)

I wonder how it is possible that he has shown a blocking message despite
having the sentence set isolation to dirty read;

The really weird thing is that this error occurred after executing a Select
statement.

My environment is 11.70FC8 in HP-UX 11.31

Thanks in advance.

Response:

Well there's a couple things that pop to mind. First is isolation level is
retained, meaning that if your esql/c program happened to execute a SPL and in
the SPL it had code that did set isolation to something other then dirty
ready, but didn't set it back before leaving, then the session wouldn't be
executing at dirty read anymore (and thus could possibly wait for locks on a
select and get the lock timeout error). Also, there is the $ONCONFIG parameter
USELASTCOMMITED. That can override what you set your isolation to in the
application and cause it to use committed read last committed isolation
instead. Certain type of locks are waited on when using that isolation level
and could therefore also get the -154 timeout error. I guess first thing I
would do is verify the esql/c app is running (for it's duration) at the
isolation level you think (ie dirty read) using onstat -g ses <session #>
output. There's a isolation level field in there, and/or at least check to see
if USELASTCOMMITTED is set to something or not.

Jacques Renaut
HCL Informix Advanced Support




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

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

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

Re: Error -243 ISAM -154 with Select sentence

Fri, 04/01/2019 - 17:09
Hi Roger.

Row locks due to uncommitted transactions are ignored with "set isolation to
dirty read" in force, but select statements can still be blocked by other
types of exclusive locks. For example, you could get that result if another
session has executed the following and still has the transaction open:

BEGIN WORK;

LOCK TABLE <table-name> IN EXCLUSIVE MODE;

There might also be another session about to make a schema change,
particularly if IFX_DIRTY_WAIT has been set:


www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.sqls.doc/ids_sqs_0891.htm

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

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

Re: Informix csdk download?

Fri, 04/01/2019 - 14:44
After replying to this, I thought this information ought to be available on
the IIUG web site.

http://www.iiug.org/links/ibm.php contains a few out of date or broken links.

Focusing only on the links relevant to this question:
IBM Software Downloads - links to "IBM Support is Transforming" page.
Informix Client SDK D/L - still links to a software trials page but no
Informix trial seems be available at this location.
IBM Passport Advantage - broken link.

Is there any chance the maintainers could update this page?

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

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

Re: Informix csdk download?

Fri, 04/01/2019 - 14:36
There are three online sources I am aware of:

1. Fix Central:

If you have an up to date support contract and want the latest version you can
get it from Fix Central:
https://www-945.ibm.com/support/fixcentral/

Select "Information Management" and then "Informix Client Software
Developmennt Kit". The latest is at time of writing is 4.10.xC12W1 but select
an earlier version.

This is the best way to get it if this method is available for you.

2. Passport Advantage

https://www.ibm.com/software/passportadvantage/pao_customer.html

This should offer up to date package versions like Fix Central but is more
fiddly to use and (I think) you have to be an IBM direct customer to have
access to it.

3. Trials and demos

https://www.ibm.com/analytics/informix

Often this is a few releases behind the latest and greatest.

Click "Download the free Informix Client Software Development Kit". The
version available there at time of writing is 4.10.xC9.

All these download methods come from IBM. I am not sure what is available if
you bought through HCL. If you can't access (2) or maybe (1) as well, your
reseller or IBM business partner should be able to.

HTH
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: [41439]

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

Error -243 ISAM -154 with Select sentence

Fri, 04/01/2019 - 06:23
Hi,
We have a program esql/c that has the following sentences:

set isolation to dirty read;
set lock mode to wait 30;

The program makes several select, update and insert operations

Recently these error messages came out when executing a select statement:

error -243 (Could not position within a table) ISAM -154 (Lock Timeout
Expired)

I wonder how it is possible that he has shown a blocking message despite
having the sentence set isolation to dirty read;

The really weird thing is that this error occurred after executing a Select
statement.

My environment is 11.70FC8 in HP-UX 11.31

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

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

Re: Number and size of chunks

Fri, 04/01/2019 - 06:04
Thanks Benjamin




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

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

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

Informix csdk download?

Thu, 03/01/2019 - 17:51
Hi,

I need the ODBC driver for Informix. Where can I download the Informix csdk? I
searched all over online and IBM just keeps taking me in circles. Can anyone
assist with the right place to download it?

Thank You,

--Dave




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

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

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

New releases of utils2_ak and myexport

Mon, 31/12/2018 - 22:44
Art Kagel <art.kagel@gmail.com>
5:36 PM (6 minutes ago)
to IIUG, ids@iiug.org

Folks:

During December I have uploaded updated versions of myexport/myimport and of
the dostats_ng.ec and myschema code in utils2_ak to my website
(www.askdbmgt.com/my-utilities.html). I thought I'd kick off 2019 with a bang.

Changes include:

myimport: Improved and extended support for index or table only dbspace
remappings.

dostats_ng.ec: Fixed an old quirk that only accepted hostnames shorter than 18
characters. Expanded to 32.

myschema: Besides the --rename-auto-index option added in November I have made
some changes to the code to make it compatible with the newer GCC versions
(some sites had problems with GCC later than 4.8). Also fixed a bug affecting
disabled constraints.

Note that an APAR has been issued for dbschema and dbexport: both are failing
to print out CREATE INDEX statements for indexes built on REPLCHECK columns.
It is expected to be fixed in the version that follows 12.10.xC12W1 in 2019Q1.
This issue first appears in 12.10.xC9 IB. Myschema does not have this problem
and the "-l" option can be used to generate a schema that is compatible with
dbimport if needed.

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

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

Pages