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: Number of logical logs growing ?
Posted by: luis-silvestre-marques@telecom.pt (LUIS MARQUES) - Wed, 12 Jun 2019 21:56:45 EDT
Well, something is causing activity in the instance and consuming logical

logs.

The timestamps and ordering of the online log seem strange. All those entries

on the same second, the backup start entries before the corresponding logical

log completing.

Is the machine hibernating?

Or aome task in the Informix internal scheduler?

Maybe turning on SQLTRACE and check if it is capturing any activity?

Activating the audit log could also give some information.



The addition of logical logs is probably because you must have the parameter

AUTO_LLOG activated. According to the online documentation, it is activated if

we choose to initialize an instance during the Informix installation.









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



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



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

Re: Number of logical logs growing ?
Posted by: pierluigi.frullani@frumar.it (PIERLUIGI FRULLANI) - Wed, 12 Jun 2019 16:38:53 EDT
This is what I've found in logs at the time of crontab ontape -a jobs ( no one

was connected to the db, neither no jobs were usign it ):



17:20:01 Logical Log 47416 - Backup Started

17:20:01 Logical Log 47416 - Backup Completed

17:20:01 Logical Log 47417 - Backup Started

17:20:01 Logical Log 47417 - Backup Completed

17:20:01 Logical Log 47418 - Backup Started

17:20:01 Logical Log 47418 - Backup Completed

17:20:01 Logical Log 47419 - Backup Started

17:20:01 Logical Log 47419 - Backup Completed

17:20:01 Logical Log 47420 - Backup Started

17:20:01 Logical Log 47420 - Backup Completed

17:20:01 Performance Advisory: The logical log is running out of room during

checkpoint processing.

17:20:01 Results: Transactions are being blocked until the checkpoint is

complete.

17:20:01 Action: Increase the logical log space size.

17:20:01 Logical Log 47421 - Backup Started

17:20:01 Checkpoint Completed: duration was 0 seconds.

17:20:01 Wed Jun 12 - loguniq 47421, logpos 0x18, timestamp: 0xf964e40

Interval: 2404



17:20:01 Maximum server connections 1

17:20:01 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 1,

Plog used 1316, Llog used 3840



17:20:01 Logical Log 47421 - Backup Completed

17:20:01 Logical Log 47422 - Backup Started

17:20:01 Logical Log 47422 - Backup Completed

17:20:01 Logical Log 47418 Complete, timestamp: 0xf964e86.

17:20:01 Logical Log 47419 Complete, timestamp: 0xf964e86.

17:20:01 Logical Log 47420 Complete, timestamp: 0xf964e86.

17:20:01 Logical Log 47421 Complete, timestamp: 0xf964e86.

17:20:01 Logical Log 47422 Complete, timestamp: 0xf964e86.

17:20:01 Log file 13 added to DBspace 3.

17:20:01 Checkpoint Completed: duration was 0 seconds.

17:20:01 Wed Jun 12 - loguniq 47423, logpos 0xa400, timestamp: 0xf964ee3

Interval: 2405



17:20:01 Maximum server connections 1

17:20:01 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns blocked 0,

Plog used 47, Llog used 22



17:20:01 ** AUTO TUNING - Logical Log extended.



Any idea ?









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



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



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

Re: Join Char and Serial
Posted by: in4mixdba@gmail.com (DAVE BALIGO) - Wed, 12 Jun 2019 15:56:33 EDT
Hi Luis,



Thank you. You are absolutely right. Using the fn_to_char() wrapper around the

join column does use the index and solves the issue. Thank you for pointing

that out. The query works great now.



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



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

Re: Number of logical logs growing ?
Posted by: pierluigi.frullani@frumar.it (PIERLUIGI FRULLANI) - Wed, 12 Jun 2019 08:54:46 EDT
I can't find any interesting info on logs, but decided to go in another way.

I've removed 40 logs, stopped the db, cleared the logfile and started again.



I'm now tracking when it will add a log ( in a script ) and tail the latest

lines of log file ( ol_informix1210.log ) t try to get a pattern.



Here the output you requested:



informix:~# onstat -g cfg DYNAMIC_LOGS

IBM Informix Dynamic Server Version 12.10.FC9IE -- On-Line -- Up 3 days

02:01:17 -- 185992 Kbytes



name current value

DYNAMIC_LOGS 0



informix:~# onstat -g cfg LTXHWM



IBM Informix Dynamic Server Version 12.10.FC9IE -- On-Line -- Up 3 days

02:01:29 -- 185992 Kbytes



name current value

LTXHWM 50



informix:~# onstat -g cfg LTXEHWM



IBM Informix Dynamic Server Version 12.10.FC9IE -- On-Line -- Up 3 days

02:01:34 -- 185992 Kbytes



name current value

LTXEHWM 60



informix:~# echo "database sysmaster; select * from sysconfig where cf_name =

'DYNAMIC_LOGS' " | dbaccess



Database selected.



cf_id 23

cf_name DYNAMIC_LOGS

cf_flags 163906

cf_original 0

cf_effective 0

cf_default 2



1 row(s) retrieved.



Database closed.



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



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

Re: Number of logical logs growing ?
Posted by: luis-silvestre-marques@telecom.pt (LUIS MARQUES) - Wed, 12 Jun 2019 04:44:10 EDT
Are there any messages on the online log indicating when the logical logs are

being added?

What is the output of:

onstat -g cfg DYNAMIC_LOGS

onstat -g cfg LTXHWM

onstat -g cfg LTXEHWM



And just to be sure, what is the result of the following query on the

sysmaster database:

select * from sysconfig where cf_name = 'DYNAMIC_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: [41719]



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

Re: Join Char and Serial
Posted by: luis-silvestre-marques@telecom.pt (LUIS MARQUES) - Wed, 12 Jun 2019 04:26:03 EDT
Using the functional index, if you construct your query similar to the

following:



SELECT



s.serial_col



, c.char_col

FROM



table_serial AS s

INNER JOIN



table_char AS c



ON



fn_to_char( s.serial_col ) = c.char_col

;



Do you get a better access plan ( I did a simple test on my machine and the

plan for this query did use the indexes on both columns )?



I would also change the index function to return CHAR( 13 ) instead of

VARCHAR.









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



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



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

Join Char and Serial
Posted by: in4mixdba@gmail.com (DAVE BALIGO) - Tue, 11 Jun 2019 13:19:00 EDT
Hi,



We are running Informix 12.10.FC9W1 and have a scenario that we need to join 2

tables and join on columns where 1 column in table_char is a char(13) and the

other column in table_serial is serial. Based on certain flags in table_char

we know that the values in char(13) will be integer. Generally this join works

though we encountered the "1213: A character to numeric conversion process

failed" error and we saw it happened because the query plan changed so the

optimizer took a different route to get to the data.



I know it's not best practice to join this way. Though in the legacy system

this is the current need and I'm trying to assist in a solution. Any

suggestions on how to work with this?



We tried casting in the join to a varchar though the optimizer doesn't use the

index and the query takes a long time.

table_serial.serial_col::varchar(13) = table_char.char_col



We tried using the join order "+ORDERED" optimizer directive and this does

help. Though we know this is a suggestion and the optimizer may or may not

choose to follow the directive. We are looking for a more "guaranteed" fool

proof approach.



We also thought of using a functional index and converting the serial to a

char thereby trying to force the join on char to char instead of having the

engine doing the char to numeric conversion, though this doesn't work either.

The engine doesn't use the index and even using a directive to force the index

the query doesn't return quickly.



Here is the function and index we tried creating:

create function fn_to_char ( f1 integer ) returns varchar(13) with (not

variant);



return f1::varchar(13);

end function;



create index idx_fn_table_serial_1 on table_serial

( fn_to_char (serial_col) ) ;



Any suggestions?



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



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

Number of logical logs growing ?
Posted by: pierluigi.frullani@frumar.it (PIERLUIGI FRULLANI) - Mon, 10 Jun 2019 14:33:12 EDT
Hi all,

I'm doing some tests on ( new for me ) old 12.10.FC9IE

I have configured it on a small machine, and created a couple of small ( less

than 1G ) databases.

I've then moved logical log from rootdbs to a dedicated chunk, and so far so

good.

What I'm noticing is that the number of logical logs keeps growing also if the

machine ( and the databases ) are doing nothing.



I'll explain better: my instance is running on a machine to which I connect

only when I'm back from work, and baically I do not operate on the DB.

I've started the db with 12 logical logs, as I was used on my old 7.x DB, and

after some time I found ( as now for example ) that there are 56 logical logs.

No application is working on it, there are no application using the db and I

have also modified the onconfig file to have the DINAMYC_LOGS set to 0

The only operation to DB is a crontab that I used to have also on my old 7.x

DBs that, every 5 minutes issues an "ontape -a"



In my previous experience with IDS this was needed to avoid long transation

hanging and I have done the same here.



The only real difference is that on old IDS the logs were in rootdbs while

here I have dedicated a dbspace to them.



The Logical log on this IDS instance are quite empty:

....

....

....

47fd3f38 29 U-B---- 44704 3:42053 1500 19 1.27

47fe7fa8 30 U-B---- 44705 3:43553 1500 9 0.60

48021fb0 31 U-B---L 44706 3:45053 1500 7 0.47

47faafb0 32 U-B---- 44707 3:46553 1500 5 0.33

47fd3fa0 33 U-B---- 44708 3:48053 1500 5 0.33

477374c8 34 U-B---- 44709 3:49553 1500 98 6.53

....

....

....



Is there any way to avoid this logs automatically grow ( in number ) ?

I'm scared that they will, at a time, fill the dbspace and block some

transaction.



Thanks in advance



Pierluigi









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



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



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

Re: RSS: Different # CPUs?
Posted by: david.grove@alaska.gov (DAVID GROVE) - Fri, 31 May 2019 12:40:00 EDT
Those were my thought exactly. But, was uncertain whether RSS required

identical settings in ONCONFIG as the primary.



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



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

Re: RSS: Different # CPUs?
Posted by: khaq@i2cinc.com (KAMRAN HAQ) - Fri, 31 May 2019 04:47:50 EDT
RSS need less CPU then primary unless you are using extensively for read

operations like running complex reports. You can run using single core but

more resources may be required if promote it to primary(RSS is an HA node)









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



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



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

RSS: Different # CPUs?
Posted by: david.grove@alaska.gov (DAVID GROVE) - Thu, 30 May 2019 14:09:15 EDT
IDS 12.10.FC12

Oracle T4-1

Solaris 10 1/13



We are contemplating new hardware purchase. Specifically, several

Oracle/Fujitsu M12-1's.



Initial purchase would be with 3 cores activated (out of 6 available on

machine) for our production server.



Wondering about using one of them for RSS, but with only one or two cores

activated.



Will an RSS work, if configured with fewer CPUs than the primary?



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



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

Re: Error in SQL Linked server to Informix DB
Posted by: gi_ca2002@yahoo.com (GIANNI CANDI) - Thu, 30 May 2019 07:02:53 EDT
Hi Eric,

after a long time I resume the discussion. Unfortunately I can't solve the

problem.

This is the script that I use to create Linked Server on SqlServer.

If I remove the commentLine on 5th row I receive error 7303 (cannot

inizializate Ifxoledbc).

With the comment the Linked Server is good but there is the problem of my

first post.



DECLARE @provider NVARCHAR(4000);

SET @provider = N'Driver={IBM INFORMIX ODBC DRIVER};'



+ N'SERVICE=1526 ;' --Informix service name



+ N'PROTOCOL=onsoctcp ;' --Informix protocol

--+ N'DB_LOCALE=en_US.819; CLIENT_LOCALE=en_US.819;';



EXEC master.dbo.sp_addlinkedserver

@server =N'LS_INFORMIX', --Linked Server system name

@srvproduct=N'Ifxoledbc',

@provider=N'Ifxoledbc',

@datasrc=N'xxx@yyyyyy', --Informix Database

@provstr= @provider;









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



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



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

Re: Identifying types of temporary tables
Posted by: jacques.renaut@hcl.com (JACQUES RENAUT) - Wed, 29 May 2019 10:01:27 EDT
Original post:



Hi gurus,



I want to catch de application that is consuming a lot of space of temporary

dbspaces. I know there is no direct way to associate sessionid with use of

temporary space. Moreover, there are temporary tables that are created

internally by the engine.



Do you know when is created the following tables ?



1. when is created th_build_fffffffff ?

2. when is created th_probe_fffffffff ?

3. when is created th_tmprun_c000000d ?

4. When is created th_overflow_0xffff ?



Thanks in advance.



IDS = 11.70FC8



Response:



So 1, 2, and 4 would possibly be created by queries doing hash joins that were

large enough to not fit in memory allocated to the query (things like pdq and

the pdq onconfig setting would affect that amount of memory).



Then 3 would be a query doing a sort that had to go to disk (so again too much

data to sort everything in memory).



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



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

Identifying types of temporary tables
Posted by: rvilca@luzdelsur.com.pe (ROGER VILCA) - Tue, 28 May 2019 16:01:33 EDT
Hi gurus,



I want to catch de application that is consuming a lot of space of temporary

dbspaces. I know there is no direct way to associate sessionid with use of

temporary space. Moreover, there are temporary tables that are created

internally by the engine.



Do you know when is created the following tables ?



1. when is created th_build_fffffffff ?

2. when is created th_probe_fffffffff ?

3. when is created th_tmprun_c000000d ?

4. When is created th_overflow_0xffff ?



Thanks in advance.



IDS = 11.70FC8



Roger









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



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



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

Re: Fri May 24 08:27:36 CEST 2019 Hora Con Dat....
Posted by: benjamin.thompson@skybettingandgaming.com (BENJAMIN THOMPSON) - Fri, 24 May 2019 10:45:22 EDT
In our application testing on Linux Informix v14 is about 7% faster than

v12.10, which I believe to be mainly down to using modern compilers. I don't

know if these optimisations apply to Solaris.



Number of reads or number of writes are very broad metrics. You've already

found that updating the database statistics makes a dramatic improvement. This

suggests the optimiser is not choosing the best query plan(s) available and is

something to dig into. For the "complex query" you mention, I suggest checking

the query plans haven't materially changed and, if they have, identify the

likely cause or add query plan directives. "set explain statistics" can

usually identify where the I/O is occurring.



This contrasts with our experience where we found query plans to be consistent

after the in-place upgrade and we had no need to regather all database

statistics.



Without more detail, I can't help any further.



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



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

Fri May 24 08:27:36 CEST 2019 Hora Con Data Con
Posted by: ipons@base.cat (ISIDRE PONS ROCA) - Fri, 24 May 2019 02:45:12 EDT
Hello, everybody.

We are preparing the migration from Informix V12.10 to V14.10.



We have created a test environment and we are seeing some drawbacks in the

migration that make us doubt.



From the beginning we have observed that if you don't recreate the statistics

the performance worsens a lot (40% aprox.)



Once the statistics are recreated everything improves but the performance is

still around 13% worse.



We have observed that the number of readings increases enormously. (see data

below)



Has anyone encountered the same inconvenience?



Data:



Environment :



Solaris 11.4



Oracle-Sun-Fujitsu M10



Ldom 6cpus



Storage UFS



Statistics:

V12.10 (No statistics recreated)

Page reads --> 199145

Reads --> 1412159



V12.10 (statistics recreated)

Page reads --> 197644

Reads --> 1297046



* An improvement in the number of readings is observed.



V14.10 (No statistics recreated)

Page reads --> 205391

Reads --> 5911318



V14.10 (statistics recreated)

Page reads --> 197970

Reads --> 2337434



** Page reads = sysmaster:syssesprof.pagreads

** Reads = sysmaster:syssesprof.isreads



Times: (same complex query database from V12.10)

V12.10 --> 28.2068 seconds

V14.10 --> 32.4646 seconds









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



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



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

Windows server informix perfomance 12.X vs 11.X
Posted by: marc.moennikes@interpane.com (MARC MOENNIKES) - Sun, 19 May 2019 14:31:20 EDT
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]



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

Re: Change to Forum email submissions
Posted by: bryce@hrnz.co.nz (BRYCE STENBERG) - Wed, 15 May 2019 17:50:29 EDT
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]



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

Re: 4gl not ending FOR loop thru file for IDS ver
Posted by: ernie.knox.jr@retailbusinessservices.com (ERNIE KNOX) - Wed, 15 May 2019 14:37:29 EDT
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]



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

Re: prevent automatic generation of sbspace
Posted by: ruediger.papke@t-online.de (RUEDIGER PAPKE) - Wed, 15 May 2019 13:26:55 EDT
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]



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

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]



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

 
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