List of Contributions

Sergio Peres

AIRC

Contact Details

AIRC

My Content

1 to 20 of 50+ total

RE: onstat -c $INFORMIXDIR result

Posted By Sergio Peres Wed November 23, 2022 10:53 AM
Found In Egroup: Informix \ view thread
Thanks for reply Art, My problem is that shell do not replace variable for the correct value an dreturns error. Using Mike solution works fine and give teh correct value, I have tested over version 12 and 14 and works on both. Best regards, SP ------------------------------ Sergio Peres ...

RE: onstat -c $INFORMIXDIR result

Posted By Sergio Peres Wed November 23, 2022 10:50 AM
Found In Egroup: Informix \ view thread
Thanks for reply, It work like a charm :) Best regards ------------------------------ Sergio Peres AIRC Coimbra ------------------------------

onstat -c $INFORMIXDIR result

Posted By Sergio Peres Tue November 22, 2022 12:42 PM
Found In Egroup: Informix \ view thread
Hi, I have one script that uses onstat results as arguments, on bash I am veryfing one issue. As INFORMIXDIR appears on some variables they are not resolved by shell #!/bin/bash ONLINELOG=$(onstat -c | grep "^MSGPATH") # This command return something like $INFORMIXDIR/tmp/online.log grep "Something" ...

RE: 9628 error with binaryvar

Posted By Sergio Peres Wed August 17, 2022 08:59 AM
Found In Egroup: Informix \ view thread
Thanks for reply Art, Considering I am trying to use one query from IBM support to detect "in place alters", there are any fast alternatives? The test I made with oncheck took about 1 hour, and also using another older SQL I have found was also slow ... SELECT DISTINCT ta.tabname FROM ...

9628 error with binaryvar

Posted By Sergio Peres Wed August 17, 2022 07:37 AM
Found In Egroup: Informix \ view thread
Hi, I'm having a phenomenon with a script, on some servers it works on others with the same version of informix 14.10 or 12.10 I get this error: 9628: Type (binaryvar) not found. indicating unknowledge about this kind of field. I've been trying to find information about this error but I can't find ...

RE: sql_begintxtime convertion

Posted By Sergio Peres Sat July 16, 2022 10:02 AM
Found In Egroup: Informix \ view thread
Thanks for the reply Andreas, As I pretend to know the sql execution time, the only way to know the start time is to subtract the execution time from the sql_finishtime? Best regards, Sergio ------------------------------ Sergio Peres AIRC Coimbra ------------------------------

sql_begintxtime convertion

Posted By Sergio Peres Fri July 15, 2022 10:15 AM
Found In Egroup: Informix \ view thread
Hi, I am trying to use dbinfo to convert sql_begintxtime on syssqltrace and get wrong values. I am using the same process used for DBINFO('utc_to_datetime',sql_finishtime). I have done some research and found information about one procedure to do it, I have tested and get wrong values... CREATE ...

RE: index size

Posted By Sergio Peres Fri December 10, 2021 10:10 AM
Found In Egroup: Informix \ view thread
Thanks Art, As the problem is global I think my company is the best client... :) I will give the information about your offer. Best regards, SP ------------------------------ Sergio Peres AIRC Coimbra ------------------------------

index size

Posted By Sergio Peres Fri December 10, 2021 06:37 AM
Found In Egroup: Informix \ view thread
Hi, I am having some performance problems with last versions 12.10 and 14.10 over customers. From what I have seen over systems I don't find any problem over OS and informix, I suspect the latency is related to some modifications that my colleagues made over some tables and indexes. Can ...

RE: TIMEDATE field problem

Posted By Sergio Peres Thu September 23, 2021 12:07 PM
Found In Egroup: Informix \ view thread
Thanks for replies, I have tried GL_DATETIME and with USE_DTENV=1 works like a charm. Thanks everyone for the help, Best regards, SP ------------------------------ Sergio Peres AIRC Coimbra ------------------------------

RE: TIMEDATE field problem

Posted By Sergio Peres Thu September 23, 2021 08:59 AM
Found In Egroup: Informix \ view thread
Yes, I know the difference but as I don't find the reason for failure I try to use it... ------------------------------ Sergio Peres AIRC Coimbra ------------------------------

TIMEDATE field problem

Posted By Sergio Peres Thu September 23, 2021 07:43 AM
Found In Egroup: Informix \ view thread
Hi, I am trying to load values for one table with DATETIME field, even defining the DBDATE format the problem continues giving 1263 error... 1263: A field in a datetime or interval value is incorrect or an illegal operation specified on datetime field. my table create table bi_spoproc( ...

RE: 4GL application performance over TCP / IP connections

Posted By Sergio Peres Thu August 26, 2021 03:29 AM
Found In Egroup: Informix \ view thread
Hi, That seems network problem! The hostnames are registered on DNS? Execute: time nslookup $(hostname) to see if there are any delays on resolution Over linux, I use [netstat -an] to check if the server is listening over IPV6 or IPV4, I think there will be something similar on AIX. SP ...

RE: Fragmentation issues

Posted By Sergio Peres Thu June 17, 2021 12:31 PM
Found In Egroup: Informix \ view thread
Thanks for Reply Andreas, I am afraid that I am not invoking the process in the correct way, however as I have tables that quickly get more than 30 extents I was convinced that these situations would be detected by auto_crsd... Thanks for the info, I'll check as I'm using the default values. ...

Fragmentation issues

Posted By Sergio Peres Thu June 17, 2021 07:08 AM
Found In Egroup: Informix \ view thread
Hi, I frequently see fragmentation in tables and indexes, even though I have activated the auto_crsd task there is still fragmentation. Are there any other tasks needed? How can I get the size of tables and indexes, including fragments? Thanks in advance for any help, SP ------------- ...

RE: dbexport alternative

Posted By Sergio Peres Wed May 19, 2021 05:44 PM
Found In Egroup: Informix \ view thread
Thanks for reply Art, Sorry for my lazyness but when I see myschema results, I get satisfied and dont have searched for error meaning. I will take a look over the system to see about the required resources and test myexport. Best regards, SP ------------------------------ Sergio Peres ...

RE: Performance of 14.10.FC5 is worse compared to 12.10 is that possible?

Posted By Sergio Peres Wed May 19, 2021 05:38 AM
Found In Egroup: Informix \ view thread
Hi, open-vm-tools work fine but there are some other conditions related with virtual platform that can have performance impact. Almost of my systems run over virtual guests, on Hyper-V for example there are significant performance improvements disabling VMQ on physical adapter. Also over registry can ...

RE: dbexport alternative

Posted By Sergio Peres Tue May 18, 2021 05:01 AM
Found In Egroup: Informix \ view thread
Hi Art, Thanks for help, myschema works perfect and help me to solve my problem. I tried to use myexport but it returns errors: Error building hierarchy1! Error: -229. Myschema failed, code: 1 Best regards, SP ------------------------------ Sergio Peres AIRC Coimbra -------------- ...

RE: dbexport alternative

Posted By Sergio Peres Fri May 14, 2021 12:23 PM
Found In Egroup: Informix \ view thread
Thanks all for replies, Concerning I have tested the suggestions but I have faced some troubles, I have done some tests with this procedure: DROP FUNCTION IF EXISTS export_airc; CREATE FUNCTION "informix".export_airc(airc_dir VARCHAR(50) ) RETURNING INTEGER, INTEGER DEFINE feitos INTEGER; DEFINE ...

RE: dbexport alternative

Posted By Sergio Peres Fri May 14, 2021 07:25 AM
Found In Egroup: Informix \ view thread
Thanks for reply Art, I have tried your tools but I am facing errors, maybe I am not doing the right steps... I have run myexport -M database and it returns Errno: 24 and Myschema failed, code: 3 Best regards, SP ------------------------------ Sergio Peres AIRC Coimbra ------------- ...