CHUAN LUBio
Threads
- memory monitor
- ontape restore problem
- skip fragment question,SQL EXPLAIN differen (2 messages)
- SQL using the index
- restore question in RSS environment
- index compression on Version 12.10
- How to run below SQL without using cursor (2 messages)
- contention on dstpool
- varchar data type question
- SQL have most IO read
- system table changes
- usage space question 2
- kill idle session
- usage space question
- onbar restore problem
- onbar -r -l -X problem (2 messages)
- Long transaction problem
- Informix backup question
- detached index rebuild question
- Using ontape in alarmprogram.bat
- table copy qeustion
- onmode -I 154,-1 143 -1
- performance between dbload and external table
- Data loading quesiton (3 messages)
- update statistics
- instance copy
- How to define task execute every 100 millisecond?
- XML demo program
- How to know the current isolation level in ESQL/C?
- new features about dynamic parameter added in 12.1 (2 messages)
- question about enable compression (2 messages)
- DELETE SQL & data pages
- PERFORMANCE between TCPIP and IPCSHM CONNECTION
- tuning HDR
- CDR question on big transaction (5 messages)
- onmode -I 244 0 , onmode -I 243 0
- onmode -b
- informix on powerLinux
- upgrade from 7.31 to 9.2 (3 messages)
- virtual segment question (3 messages)
- temporary dbspace question (2 messages)
- fragment NONE (2 messages)
- Install fix
- sqlca.sqlerrd[2]
- repack (2 messages)
- onstat -k hang
- Do onmode -I block the transaction
- performance difference between dbaccess/ESQLC
- IDS restore problem in Win7 (2 messages)
- How to get the timestamp value in the data page?
- select for update (2 messages)
- non-print character
- prepare error 410
- how to prepare the fetch SQL?
- prepare the SQL in the sub-routine
- SQL question (3 messages)
- maxsortspace
- truncate table
- transaction quesiton
- non-log and logical log buffer
- onmode -B
- dotnet and connection manager
- onmode -I question (2 messages)
- ER question
- lock problem
- CLI question
- overhead of large pagesize
- onlog question
- question about fragment
- DS_NONPDQ_QUERY_MEM and hash table
- How to control informix user access the user data (2 messages)
- Long transaction
- Information in partition header page
- execute dbimport in SDS node
- transaction survial in 11.7
- How to monitor the memory usage of OLTP and OLAP
- what the mainloop thread used for?
- PSORT_NPROCS
- How to avoid the starting of IDS in standby box?
- level-1 and levle-2 backup
- level-1 and levle-2 backup
- Informix question
- TBLTBLFIRST/TBLTBLNEXT
- How to get the sequence value in ESQL/C program? (2 messages)
- Could I execute ontape,onbar oronunload on HDR SEC
- Could I execute ontape/onbar/onunload on HDR SEC
- compression on datetime data type
- trigger question
- How to capture the lock wait or dead lock info
- fractions between two datetime columns (2 messages)
- How to know the database name create on a dbspace?
- How to see a part of information in clob in SP (3 messages)
- document about function cloboutput (2 messages)
- How to call java program in the SQL function (2 messages)
- How to change data type of rowsize column to int ?
- Risks on mode ansi DB
- about DRLOSTFOUND
- SQL LOAD become slower in IDS11.50FC6
- the performance of SQL LOAD decrease in IDS11.50FC
- dbload and load
- ontape problem on IDS9.4FC5 for AIX (2 messages)
- How to disable auto update statistics
- How to know the table name
- question about row type
- How many fractions between two datetime variable?
- How to config SSL
- How to truncate the data in one partition
- multiple result set (2 messages)
- question about Informix CLI on windows
- onpladm qeustion
- clob question
- trigger problem
- physical log problem
- question about cursor fetch (2 messages)
- update statistics high/medium and performance
- temporary table display problem in 'onstat -g sql'
- SQL execute frequently
- how to convert $enter to informix in oracle
- How to convert oralce chr() function to informix
- hashtemp.th_overflow_ffffffffffffffff in openview
- Index usage scripts
- Do SHMVIRT_ALLOCSEG really prevent run out of mem
- ids 10 & 11 performance on aix and hp platform (2 messages)
- Could IDS 11.10FC2 run at HP-UX 11iV3?
- IDS 11 sds problem
- How to audit the operation from dbaccess or isql (2 messages)
- Transaction rollback and set lock mode to wait 3
- Re: RE: Update statistics performance