Save 
Join IIUG
 for   
 

RSS Feed: IDS Forum: IDS

More IIUG RSS Feeds

The IDS Forum is a discussion forum to communicate about all aspects of the Informix Dynamic Server (IDS) Engine


URL: http://www.iiug.org/rss/ids.rss

Below is the latest content available from this feed:

Re: Invalid Pool Name error
Posted by: jhenry@gwkinvest.com (JOHN HENRY) - Fri, 22 Feb 2019 17:59:58 EST
I want to thank Andreas Legner who suggested running ism_startup with the

-init switch to recreate the pool devices.



create_pool Backup ISMDiskData



create_pool Backup ISMDiskLogs



create_pool Backup ISMData



create_pool Backup ISMLogs



looking at the ism_startup script I saw this note



# The -init switch will cause the ISM server to be setup for the first time.

# Using this switch more than once will cause "create failed:" messages to

# appear, but will otherwise cause no harm.



So I felt it was safe to do. when I ran it I received no errors or create

failed messages. So some need pieces must have gone missing in the

environment.



after running ism_startup -init I was able to label the device and mount it.



I had to create a new label rather than use the existing label. I could have

deleted the existing label and reused it as an alternative.



end result is that my issue is resolved.



Thanks again Andreas!









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



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



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

Re: use of exists
Posted by: jhenry@gwkinvest.com (JOHN HENRY) - Fri, 22 Feb 2019 10:31:26 EST
No worries, we all start at th ebegining









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



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



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

Re: -951 trap
Posted by: mark.jalkiewicz@verizon.net (MARK JALKIEWICZ) - Fri, 22 Feb 2019 10:15:42 EST
Sergio, Luis and Benjamin,



Thanks for all of your responses.



Regards,



Mark









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



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



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

Re: use of exists
Posted by: sergio.peres@airc.pt (SERGIO PERES) - Fri, 22 Feb 2019 06:25:16 EST
Sorry for my mistake, I am SQL newbie :)









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



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



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

Re: use of exists
Posted by: sergio.peres@airc.pt (SERGIO PERES) - Fri, 22 Feb 2019 06:25:10 EST
Sorry for my mistake, I am SQL newbie :)









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



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



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

Re: use of exists
Posted by: jhenry@gwkinvest.com (JOHN HENRY) - Fri, 22 Feb 2019 06:01:08 EST
well that's a syntax error, can you share the exact code that gives you that

error? Have you run this code in a procedure?



if exists(select 1 from systables where tabname ='tableforsearch')

then



select * from tableforsearch;

end if



This code needs to be run inside of a procedure, if you are trying to run it

in a sql editor window, from a tool like server studio, you will get a -201

syntax error.









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



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



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

Re: use of exists
Posted by: sergio.peres@airc.pt (SERGIO PERES) - Fri, 22 Feb 2019 05:06:09 EST
Thanks for your reply,



I already have tried something like that and always get syntax error 201.



I am using 12.10.FC10 version...



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



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

Re: -951 trap
Posted by: benjamin.thompson@skybettingandgaming.com (BENJAMIN THOMPSON) - Fri, 22 Feb 2019 05:04:51 EST
Hi,



One option is to use a product which can ingest and parse logs, and generate

reports based on that. Elasticstack is an open-source example of this with a

commercially supported version available. Other similar tools exist.



Alternatively and more straightforwardly you could use the imfile module of

rsyslog to write the Informix log entries to a file in /var/log, assuming

you're using Linux. This may fit with an existing solution where all [r]syslog

files in /var/log are monitored by security, especially /var/log/secure, which

I'd imagine they are interested in.



I wouldn't recommend using "onmode -I" as someone else has suggested which can

be a nightmare in general with which to capture frequently occurring events.

It will generate a stack track each time and potentially a shared memory dump

which will block the server while it takes place as well as consume a lot of

disk space.



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



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

Re: -951 trap
Posted by: luis-silvestre-marques@telecom.pt (LUIS MARQUES) - Fri, 22 Feb 2019 04:25:28 EST
You can try setting ALRM_ALL_EVENTS to 1 in ONCONFIG (requires a restart of

the Informix instance).

Then there will be an event triggered for a failure to authenticate:



CLASS_ID=42

EVENT_ID=42001

CLASS_MSG=Event occured

SPECIFIC_MSG=listener-thread: err = -951: oserr = 0: errstr = XXXX@YYYY:

Incorrect password or user XXXX@YYYY is not known on the database server.



Unfortunately, CLASS_ID 42 seems to be a catch all for a lot of events. You

will need to edit the alarmprogram script to parse the SPECIFIC_MSG for the

-951 error.



And with ALRM_ALL_EVENTS=1 the Informix server will be calling the

alarprogram.sh much more times, so performance may suffer.



Best regards,

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



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

Re: use of exists
Posted by: jhenry@gwkinvest.com (JOHN HENRY) - Thu, 21 Feb 2019 19:47:27 EST
This is one way,



if exists(select 1 from systables where tabname ='tableforsearch')

then



select * from tableforsearch;

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



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

Re: -951 trap
Posted by: sergio.peres@airc.pt (SERGIO PERES) - Thu, 21 Feb 2019 15:55:01 EST
Hi Mark,



I think you can do it with onmode -I 951.



https://www-01.ibm.com/support/docview.wss?uid=swg21155532



Regards,



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



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

use of exists
Posted by: sergio.peres@airc.pt (SERGIO PERES) - Thu, 21 Feb 2019 15:50:14 EST
Hi,



I am trying to develop one query over databases to look for the existence of

one table. I am using the exists clause but I am receiving error 206.

My query is:

select * from tableforsearch where exists (select * from tableforsearch)



Is this the correct way to do it?

How can I do it?



Thanks for any help,



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



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

-951 trap
Posted by: mark.jalkiewicz@verizon.net (MARK JALKIEWICZ) - Thu, 21 Feb 2019 15:13:58 EST
Folks,



IDS 11.70 AIX 7.4



Is there any way/method etc. to trap for the following authentication error

and send out an alert to security admins ? (other than greping the msg log )



951: Incorrect password or user is not known on the database server.



Preferably would like to have the alarmprogram fire when this occurs but have

not found an alarm event id associated with the -951.



Thanks in advance,



Mark









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



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



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

column addition in er replication
Posted by: khaq@i2cinc.com (KAMRAN HAQ) - Thu, 21 Feb 2019 11:05:27 EST
We are planning to use er replication. During testing phase we created the

replica using template but found that column addition is not being replicated.

We did not find any switch/flag in defining or realizing the template that

enforce the schema synchronization as we can do in case of replicates(using

--name=y)

Here are the steps we followed:



cdr define server -A /tmp/er108t/atsdir -R /tmp/er108t/risdir -c

ids_net_pri_108t --init ergrp2



cdr define server -A /tmp/er108t/atsdir -R /tmp/er108t/risdir -c

ids_net_rep_108t -L -S ergrp2 --init ergrp



cdr define template empdept -C ignore -S trans --master=ergrp2

--database=testdb



cdr realize template empdept ergrp2

cdr realize template empdept -c ergrp2 --autocreate --syncdatasource=ergrp2

--extratargetrows=keep --target ergrp



Here ergrp2 is master node. But adding column on master node does not

replicate on other partitipant node



We are using informix 12.1FC7



regards,

Kamran









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



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



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

Stored Procedure RFE
Posted by: cesar.inacio.martins@gmail.com (CESAR MARTINS) - Thu, 21 Feb 2019 10:24:41 EST
Hi,



If you work with Stored Procedures and fell they are lack of resources, please

check the RFE about.





https://ibmanalytics.ideas.aha.io/ideas/search?project=INFX&query=procedure&utf8=%E2%9C%93



https://ibmanalytics.ideas.aha.io/?project=INFX&sort=recent



Vote to help them to be considered by HCL to implement soon.



Some of the requests :

* Improve Stored Procedures features

* Allow UDRs run with owner privileges

* Encrypt source code for procedure/function

* Ability to re-create views and procedures without dependent objects being

dropped

* Implement CREATE OR REPLACE option for stored procedures









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



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



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

Invalid Pool Name error
Posted by: jhenry@gwkinvest.com (JOHN HENRY) - Wed, 20 Feb 2019 14:57:40 EST
Hi All, I posted a question previously about a "bad file number" error I was

receiving when issuing this command, "ism_op -mount /backups/txlogs". I

haven't had any luck resolving it. Today I decided to try a work around. I

Dropped the device "ism_rm -device /backups/txlogs" and then tried to create

it again "ism_add -device /backups/txlogs" and got the same error "bad file

number". So I created a new directory /backups/txlogss, I then copied all the

files from /backups/txlogs to /backups/txlogss. Once that was done I deleted

the /backups/txlogs directory and then moved the directory /backups/txlogss to

/backups/txlogs. Once that was done I tried creating the device again,

"ism_add -device /backups/txlogs", this time the device created! I then tried

to label the device so that I could mount it;



ism_op -label /backups/txlogs -volume TxLogs20180120 -pool ISMDiskLogs



And the GODS are against me, I got an error



nsrmm: Invalid pool name `ISMDiskLogs'.



Now I know the pool name is valid and double checked in the ISM_LOG_POOL value

in the onconfig file and it is



ISM_LOG_POOL ISMDiskLogs



Can anyone help?









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



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



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

SQLlines Converter Tool
Posted by: ddmueller@west.com (DAN MUELLER) - Wed, 20 Feb 2019 12:39:38 EST
Hi Folks,



I have been tasked to convert an Informix database to PostGres using the

SQLlines tool. Has anyone used this tool or performed a like conversion? I

could use some help here.



Thanx,

Dan









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



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



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

Re: IBM Informix RFE gone?
Posted by: cesar.inacio.martins@gmail.com (CESAR MARTINS) - Tue, 19 Feb 2019 06:37:49 EST
https://ibmanalytics.ideas.aha.io/?project=INFX&sort=recent



New link to Informix RFE.









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



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



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

Re: INH mutex
Posted by: benjamin.thompson@skybettingandgaming.com (BENJAMIN THOMPSON) - Mon, 18 Feb 2019 13:02:09 EST
Hi Jacques,



Thanks for replying. It doesn't give me an immediate solution but does gives

me some pointers.



We don't use special row types or typed tables but this particular table does

have a large number of dependent tables (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: [41500]



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

Re: INH mutex
Posted by: jacques.renaut@hcl.com (JACQUES RENAUT) - Mon, 18 Feb 2019 11:12:09 EST
Original post:



Hi,



Does anyone know what area of the engine the "INH list" mutex protects? I am

seeing a large number of waiters on this mutex under heavy load. I suspect it

may relate to access to the in-memory lock table but I am really only

guessing. I can't find any reference to this online.



A typical wait on this mutex looks like:



tid name rstcb flags curstk status

236362 sqlexec 4cc025288 S--P--- 7136 mutex wait INH list -



Sess SQL Current Iso Lock SQL ISAM F.E.

Id Stmt type Database Lvl Mode ERR ERR Vers Explain

235372 UPDATE user_db CR Wait 15 0 0 9.28 Off



Current SQL statement (107133) :

update my_table set my_col = my_col where id = ? and my_col = 'P'



Host variables :



address type flags value



-----------------------------------------



0x00000003d978d6f0 INT8 0x000 20064788376



The session is doing some kind of dummy update to lock the row.



Ben.



Response:



That mutex name has something to do with inheritance and the inheritance

cache. Not sure that that helps you any, and I have not really seen that show

up myself. Not sure if that's something that will always be checked, or if you

have to create your tables/schema in specific way (like using named row types

or typed tables).



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



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

Original post:



Hi,



Does anyone know what area of the engine the "INH list" mutex protects? I am

seeing a large number of waiters on this mutex under heavy load. I suspect it

may relate to access to the in-memory lock table but I am really only

guessing. I can't find any reference to this online.



A typical wait on this mutex looks like:



tid name rstcb flags curstk status

236362 sqlexec 4cc025288 S--P--- 7136 mutex wait INH list -



Sess SQL Current Iso Lock SQL ISAM F.E.

Id Stmt type Database Lvl Mode ERR ERR Vers Explain

235372 UPDATE user_db CR Wait 15 0 0 9.28 Off



Current SQL statement (107133) :

update my_table set my_col = my_col where id = ? and my_col = 'P'



Host variables :



address type flags value



-----------------------------------------



0x00000003d978d6f0 INT8 0x000 20064788376



The session is doing some kind of dummy update to lock the row.



Ben.



Response:



That mutex name has something to do with inheritance and the inheritance

cache. Not sure that that helps you any, and I have not really seen that show

up myself. Not sure if that's something that will always be checked, or if you

have to create your tables/schema in specific way (like using named row types

or typed tables).



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



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

 
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