List of Contributions

AMIT PATEL

Contact Details

My Content

1 to 20 of 50+ total

IDS 12.X EOS

Posted By AMIT PATEL Wed March 06, 2024 02:09 AM
Found In Egroup: Informix \ view thread
Hello All, Can anyone tell me, is there any information for IDS 12.X EOS. if EOS is nearby my company will try to upgrade with 14.x. Thanks Amit Patel ------------------------------ AMIT PATEL ------------------------------

IDS 14.10 Download

Posted By AMIT PATEL Tue January 09, 2024 06:24 AM
Found In Egroup: Informix \ view thread
Hello everyone, Happy new year to All. Can someone please let me know how can I download IDS 14.10 from IBM passport advantage site? I'm not getting information/option to download. Thanks Amit Patel ------------------------------ AMIT PATEL -- ...

RE: Memory issue on Informix primary server

Posted By AMIT PATEL Mon February 14, 2022 10:54 PM
Found In Egroup: Informix \ view thread
Thanks Art, But total of virtual segment is 518617300992 Bytes means (518 GB) , which looks much to replace with current total shared memory. SHMVIRTSIZE 31457280 (31GB) and as per "onstat -g osi" system memory is System memory 781568 MB. So is there any other resource we can change Art? ...

Memory issue on Informix primary server

Posted By AMIT PATEL Mon February 14, 2022 04:02 AM
Found In Library: Informix
#Informix

Memory issue on Informix primary server

Posted By AMIT PATEL Mon February 14, 2022 04:02 AM
Found In Egroup: Informix \ view thread
Dear All, We have upgrade our Informix server from 11.7 to Version 14.10.FC6X3 on Sun OS 5.11. After that We are facing multiple memory segment issue on Primary server, but everything is normal on Secondary server. Before Upgrade there was only on Virtual memory segment. ...

Index in Temp table

Posted By AMIT PATEL Tue September 14, 2021 04:53 AM
Found In Egroup: Informix \ view thread
Dear All, I'm running below query to delete data. Using Index on Temp Table: CREATE TEMP TABLE temp2 (cust_numb INTEGER); CREATE INDEX "informix".temp2_n1 ON temp2(cust_numb) using btree; INSERT INTO temp2 select first 10000 cb.cust_numb from optim_cs_csdi cb WHERE EXISTS (SELECT op.cust_numb ...

RE: Shared Memory

Posted By AMIT PATEL Mon September 13, 2021 05:53 AM
Found In Egroup: Informix \ view thread
Thanks Art, I changed SHVIRTSIZE as per your Comments. Currently Instance running fine :) Thanks . ------------------------------ AMIT PATEL ------------------------------

Shared Memory

Posted By AMIT PATEL Fri September 03, 2021 06:10 AM
Found In Egroup: Informix \ view thread
Hello, Today I checked the Informix shared memory by onstat -g seg on Informix 14.10FC6X3 informix [rs-om-ifx-201] on_nebula21 $ onstat -g seg IBM Informix Dynamic Server Version 14.10.FC6X3 -- On-Line -- Up 16:43:49 -- 10327040 Kbytes 2021-09-03 15:36:42 Segment ...

SQL Time

Posted By AMIT PATEL Thu August 12, 2021 08:22 AM
Found In Egroup: Informix \ view thread
I'm running below query with set explain on. QUERY: (OPTIMIZATION TIMESTAMP: 08-12-2021 18:44:05) ------ select count(*) from cs_subr_pcn_00 cb WHERE EXISTS (SELECT cl.cust_numb , cl.subr_numb from cs_cust cs, cs_clse_cust cl WHERE cs.cust_numb = cl.cust_numb AND ...

Extent size and data forecast

Posted By AMIT PATEL Thu August 12, 2021 06:59 AM
Found In Egroup: Informix \ view thread
Hello everyone, Please tell me the simple formula for calculating the INITIALI and NEXT extent size for below criteria. TABLE "informix".cs_cust row size = 758 number of columns = 50 index size = 331 If customer says table growth rate 100000 rows per month. We have 2 GB chunk size and ...

DB connection

Posted By AMIT PATEL Mon August 02, 2021 06:59 AM
Found In Egroup: Informix \ view thread
Dears, I need to write few SQL statement which where I can use temp table in joins. But it is giving syntax error. As I know Unix command can not be run under informix session. Is there any other way to do it? Table names are in loop, so can't use hard coded. CNT1="SELECT COUNT(*) FROM optim_cs_blcs ...

RE: LIMIT DELETE ROWS

Posted By AMIT PATEL Wed June 30, 2021 10:34 PM
Found In Egroup: Informix \ view thread
Thank you Art :) ------------------------------ AMIT PATEL ------------------------------

LIMIT DELETE ROWS

Posted By AMIT PATEL Wed June 30, 2021 06:44 AM
Found In Egroup: Informix \ view thread
Hello All, Can we Limit the Delete Records in Informix? Or Is it possible to set number of record deletion per Commit? Thanks Amit Patel ------------------------------ AMIT PATEL ------------------------------ #Informix

multiple table Data deletion

Posted By AMIT PATEL Sun June 13, 2021 11:28 PM
Found In Egroup: Informix \ view thread
Hello All, I have to delete data from multiple table (around 300) , kindly suggest what precaution should I take while data deletion that Process should not get aborted due to LOCK or LOG and LONG TRANSCTION. (Working on IDS 11.70). There are separate queries , All 300 tables has joins with ...

RE: AUTO INCREMENT Value

Posted By AMIT PATEL Fri June 11, 2021 03:33 AM
Found In Egroup: Informix \ view thread
Dear Art, I entered first record with some value like 10000001 and from next time entered value 0 , so it is taking next values like 10000002 , 10000003 .... :) Thanks Amit Patel ------------------------------ AMIT PATEL ------------------------------

RE: AUTO INCREMENT Value

Posted By AMIT PATEL Fri June 11, 2021 02:36 AM
Found In Egroup: Informix \ view thread
Thanks Art, I forgot to write few thing in that. Can We set a default value against that column, like the value should start from 1000 and then auto increment by 1. 1001 , 1002 .... Kindly revert. Thanks Amit Patel ------------------------------ AMIT PATEL ------------------------ ...

AUTO INCREMENT Value

Posted By AMIT PATEL Thu June 10, 2021 06:22 AM
Found In Egroup: Informix \ view thread
Hello All, I'm working on Informix 11.70. I have created an sequence and for incremented value I'm using (Sequence_name.nextval) every time. But is possible in Informix that if I enter '0' or NULL then also field value should increment automatically by 1 or any integer value. Kindly ...

Long Running Query thru shell Script

Posted By AMIT PATEL Fri May 28, 2021 08:16 AM
Found In Egroup: Informix \ view thread
Hello All, I need to write a shell script to find long running Query in Informix 11.70. (We will upgrade with 14.10 in August 2021). As it includes three main steps 1. Search onstat -g act -g -x (x= 1, 2, 3, 4, ....) 2. Check tcb column with Non ZERO value and run onstat -u | grep o ...

EOS Date

Posted By AMIT PATEL Fri May 21, 2021 03:09 AM
Found In Egroup: Informix \ view thread
Hello All, I was searching for the Informix 10.00 FC10W2 End Of Support date. Not getting any information in google. If someone has any information , kindly let me know. Thanks Amit Patel ------------------------------ AMIT PATEL ------------------------------ #Informix

RE: DBACCESS - Comand not found

Posted By AMIT PATEL Tue May 18, 2021 04:35 AM
Found In Egroup: Informix \ view thread
Dear Andreas, If I login as informix user and type "env" command I get following But when I do "env" from normal user login So Do I need to export the command which you mentioned earlier , to do the needful. Kindly confirm. Thanks Amit ------------------------------ AMIT PATEL ...