Threads from 2021
Browse by month: Jan · Feb · Mar · Apr · May · Jun · Jul · Aug · Sep · Oct · Nov · Dec
Happy New Year
To All. I wish all of you all of the best in 2022. Have a Happy New Year in 2022. Scott Pickett IBM Informix WW Technical Sales IBM Expert Labs IBM Informix WW Cloud Technical Sales IBM Expert Labs IBM Informix WW Cloud Technical Sales ICIAE IBM Expert Labs IBM Informix WW Inform…
Informix 4GL Resources for Developers
Happy New Year! I taught an Informix 4GL for Developers course this month. I had fun doing that class and working with this superb language. I pulled together this list of 4GL Resources for the course based on articles I have written in the past. Here is my blog post on this. ht…
Update to utils2_ak
I posted an updated utils2_ak to my web site. It contains a critical fix to dostats_ng.ec and a couple of new features in dostats_ng.ec and in myschema. www.askdbmgt.com/my-utilities ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Mana…
flags (onstat -g ses)
Hello i have some sessions with status "running" and flags "---P---" , not doing or waiting for anything, other sessions are on "---PR--" (reading) what does "---P---" mean please ? Thanks ------------------------------ John Smith ------------------------------ #Informix…
How many aio/KAIO
Hello All When using KAIO, what is recommended for vpclass CPU and AIO please ? Thanks ------------------------------ John Smith ------------------------------ #Informix…
Informix XA datasources in JBoss EAP 7 application server?
Is there anyone who have successfully configured XA datasources for Informix (14.10) in JBoss application server (EAP 7)? And who also have gotten it to work with an HA setup with multiple connection managers? I struggle a bit putting the pieces together here. -------------------…
What are the licensing considerations for InformixHQ?
Howdy! Wondering if anyone knows what are the licensing considerations for InformixHQ? I know people who are running 11.7, obviously no longer under support. with that in mind, and considering that HQ might work with 11.70, HQ could be extracted from, say, the IIUG development ed…
UDR improvement suggestions
In the following SQL: SELECT fname, lname, ssn from tab1 where lname like "%vijay%" AND ( telephonenumber IN ((123)456-7890 , ......, ....) OR homephone IN (+123 456-7890, ......, ....... ) OR mobile IN(123-456-7890, ....,.....,....) Custer wrote an UDR to take out all extra non…
New utils2_ak and myexport features!
Folks: I have uploaded new releases of my utils2_ak and myexport packages on my web site ( My Utilities ). Here are the highlights: Myschema adds a new option, --myexport-binary, that produces unload and load scripts that use EXTERNAL TABLES to unload data in INFORMIX binary form…
Informix on RHEL on VMWare - cooked vs. raw devices recommendation
Hello, I need some advice what is better solution for Informix 12.10 on RHEL 7 in VMWare VM - cooked file or raw devices? From performance point of view? Thanks a lot. ------------------------------ Milan Rafaj Infrastructure Architects and Specialists Team Leader Kyndryl +42073…
Index in Temp table
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…
Problems with temporary dbspaces
Dear colleagues: I come to you, because it is the first time that I have encountered this problem, which I have investigated a lot through documentation and I cannot find the solution. I have an Informix IDS 7.31 TD6 engine on Windows 10, which is mounted as a test, to be able to…
Linux Informix ODBC driver
So ... trying to find the CSDK for Linux that has the INFORMIX ODBC driver. The latest (or at least what I pulled down) for Linux has, get this, the db2 drivers (!). IBM/HCL confirmed that this is the case in the PMR I opened. But they haven't responded to my escalation - apparen…
Index creation strategy when autolocate is set
Hello All, If autolocate is set to a value greater than 1, the table is created with a round-robin schema, but indexes cannot be created with a round-robin schema. I would like to know if there are any best practices on how to create indexes in a database that is set to autolocat…
Shared Memory
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 Summary: id …
SQL Time
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 cl.cust_numb =…
DB connection
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(…
Possible CM / CSDK 4.50.FC6 / SSL Issue
FYI: I recently updated a couple of our connection managers from 4.50.FC5 to 4.50.FC6 (CentOS 7). After doing so, I started periodically seeing these errors: 00:22:06 listener accept new fd failed:network error = -28014 cannot accept Eventually (typically after about 3-5 days of …
Informix Client CSDK Parameters
Hi All, I am trying to improve network performance between client server comunication. I am not finding documentation about Parameters on Infomix Client CSDK to try improve this comunication ? (like parameters to improve TCPIP Buffers, etc...).. now 2/3 of time is spending in …
Informix NoSQL syntax in SQL + UDR way / Not mongoDB way
Hi all, I am at the moment testing using NoSQL data in some tables ( stored as BSON), thru the use of ESQ/C or 4GL language All good when I read data from the table, that is LET qry_stmt = "SELECT acct_code,desc_text,start_year_num,start_period_num,end_year_num,end_period_num,gro…
Informix 14 - ALTER JOIN -
INFORMIX OUTER JOIN - We upgrade server to Version 14.10 FC5 , we are facing a performance issues in queries who uses OUTER JOIN . Comparing in the same machine / same configuration, between verions 12.10 FC14 and 14.10 FC5, queries who uses OUTER join are 4 times slower, other…
ontape does not finish the backup: tape full
Hi all, We have a cron job running at 22:00 hrs to backup our database. I have no clue why ontape is aborting. I hope I have entered enough info below. The resulting bzip compressed file is 240G one day, 253G the next, so it is aborting on different sizes and also after different…
What is an esql++ file?
Hello All, My client is planning to change the machine of the Informix server and client from AIX to RedHat Linux. However, there is an esql++ file in the $INFORMIXDIR/bin directory of the old client, but it doesn't seem to exist in the latest version. Does anyone know about this…
Finding the CSDK v4.50.xC6
Folks: It looks like IBM messed up again. If you are looking to download the latest CSDK (v 4.50.xC6) you will not find it on the CSDK download page. It was mistakenly put on the Informix Engine Developer Edition download page. All earlier releases of the CSDK are on the CSDK dow…
LIMIT DELETE ROWS
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…
Informix Windows issue: ERROR: Could not initialize the security subsystem.
Windows 10 default installation + updates, IDS 14.10.FC6DE (tested with IE, WE, Ent, Exp) Figure #1 My user Hrvoje is member of Administrators and Informix-Admin Registry has HLM\\Software\\Informix\\Online\\%INFORMIXSERVER%\\Security including "IXDBSA Group" -> Informix-Admin Wh…
Unload over writes existing files
Got tired of unload files being overwritten by mistake - https://ibm-data-and-ai.ideas.aha.io/ideas/INFX-I-412 Cheers Paul Paul Watson Oninit www.oninit.com Tel: +1 913 674 0360 Cell: +1 913 387 7529 Oninit® is a registered trademark of Oninit LLC Failure is not as frightening as…
multiple table Data deletion
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 h…
How to check autolocate settings ?
Hello All, After setting AUTOLOCATE of onconfig to 3 as shown below, I set the location of the database using the administration API. The table seems to be successfully created in the specified dbspaces, but sysmaster:sysautolocate does not show the specified dbspace list. Is thi…
A bit more clarity on LEVEL 1 backups
Hi, maybe a dumb question, but I just want to know for sure. In the documentation I read that a LEVEL 1 backup contains all data that has changed since the last LEVEL 0 backup. So this would mean that I make a LEVEL 0 on Sunday I make a LEVEL 1 on Monday evening I make a LEVEL 1 …
CSDK
Ifmx 12.10.FC14 Solaris 10 1/13 Our developers work in Java. I do DBA and sysadmin work on our Solaris/SPARC systems. The point is I haven't done much with Windows. I have a developer now who needs to use dbaccess from his WIndows 10 machine. So, I need to install a Windows CSDK…
oncheck -cDI >>> inconsistency warning
Hello, In an oncheck before upgrade that i took from here https://youtu.be/xsylAz5U1sY?t=1374 oncheck -cDI devdb https://www.ibm.com/docs/en/informix-servers/12.10?topic=utility-oncheck-cd-oncheck-cd-commands-check-pages https://www.ibm.com/docs/en/informix-servers/12.10?topic=ut…
With IDS 14.10.FC5 ALTER TABLE of VARCHAR truncates trailing blanks
Hello! With IDS 14.10.FC5 (no problem with IDS-12.10.FC9IE): When changing the size of a VARCHAR column with ALTER TABLE, trailing spaces are removed. While CHAR columns are blank-padded, to me trailing blanks in VARCHAR columns are part of the value, even if they are not signifi…
Blocking Checkpoint?
Ifmx 12.10.FC14 Solaris 10 1/13 What does it mean when a checkpoint shows "# Waits" = 1, but "Block Time", "Ckpt Time", "Wait Time", "Long Time" are all zero? Critical Sections Physical Log Logical Log Clock …
Documentation - Upgrade from IDS 12 to 14 in primary/HDR/RSS configuration
Hello, I looked for information about upgrading primary/hdr/rss from IDS12 to 14 But I only found for IDS11 https://www.ibm.com/support/pages/upgrading-high-availability-data-replication-hdr-pair Do I have to go through the same steps for 12 to 14? Also, Step 4: I could understan…
Updates to myschema and myexport
Folks: For a long time I have wanted to change how the -O (dependence ordering) works in myexport. Originally it used myschema --dependency-order which guarantees that parent tables are unloaded and loaded before their dependent tables. This option avoids inconsistencies caused b…
dbexport alternative
Hi, I need to clone informix databases with some frequence, I know there is dbexport but it implies to have no connections. I would like to have some way to do it without downtime. I have tryed to clone with some old scripts I have, but I facing one problem with referencing const…
New utils2_ak features!
Folks, I have uploaded an update to utils2_ak that includes new features in myschema to support new myexport features similar to recent improvements to dbexport. I will shortly release an update to the myexport package that includes direct support for these. In the meantime, you …
ontape -l show 100% full logs but ontape -a doesn't flush them
Hello, IBM Informix Dynamic Server Version 12.10.FC5 When I issue "onstat -l", I get: Physical Logging Buffer bufused bufsize numpages numwrits pages/io P-2 43 256 53 1 53.00 phybegin physize phypos phyused %used 2:53 …
Asking for a real IDS Tableau driver
For those who know Tableau, you will agree that it is a great product with great features. For those who don't, it's a great product for BI reports and more. Unfortunately, IDS is not part of the supported drivers for Tableau, making that some functionality just do not work with …
Could I force drop the database?
Hello All, I would like to ask for advice on Informix error message. A specific database of the instance has fallen into an inaccessible state. Below is the result of running the oncheck -cc command and dbaccess. Fortunately, it is an unused DB, so I want to know if it is possibl…
New utils2_ak feature!
I have uploaded an update to utils2_ak that contains an update to the dbstruct utility. There is now an option, -l, to produce a simple comma separated column list suitable for inclusion in a SELECT's projection clause or in some code situations. ------------------------------ Ar…
New RFE - CSDK support for static links under the latest GCC releases
If you find this RFE relevant to your systems, please vote for it: Currently the only way to produce a statically linked utility using ESQL/C is to compile and link with a GCC release earlier than 5.5. The latest is v10. https://ibm-data-and-ai.ideas.aha.io/ideas/INFX-I-406 -----…
informixHQ without informix
Hi, Concerning I have some java problems with some of our programs. As OAT, can informixHQ run outside informix server only with CSDK installed? SP ------------------------------ Sergio Peres AIRC Coimbra ------------------------------ #Informix…
Things Fail! - Getting Serious About Redundancy! by Tom Girsch an Informix Tech Talk this week
Things Fail! - Getting Serious About Redundancy! by Tom Girsch an Informix Tech Talk this week. Date: Thursday, April 29, 2021 2:00pm EDT Please register at: https://www.iiug.org/en/services/next-webcast/ Join us for a great discussion on how to plan and avoid failures in compute…
Things to do before upgrade - HDR/RSS
Hello As i can see here , there are a bunch of things to do or check before upgrade (IDS12 > 14). But do I have to do all this on all the servers ? For example, UDRs Do i have to recompile them also on the HDR and RSS ? (Also, if you have a link to UDR compile/recompile process, …
How to find which dbspaces are set to auto extend?
Howdy y'all! I understand what needs to be done to do make a dbspace auto extendable: Mark the chunk(s) extendable: DATABASE sysadmin; EXECUTE FUNCTION task("modify chunk extendable", "12"); Set the SP_THRESHOLD onconfig setting. Change how often the mon_low_storage task runs: …
Temp dbspace usage
Hello everyone, Hope all are safe and healthy in this pandemic. How can I check which query/session or activity is using more Temp dbspace. We have total 32 GB temp dbspace (16 temp dbspaces with 2 gb chunk each). Currently gets warning message for Temporary dbspace is 94% used …
archecker utility on ontape level 1 archive
Hi, when I run the archecker utility on a level 0 archive taken with ontape, it runs fine and gives me PASSED and exits 0. When I run it on a subsequent level 1 archive, I get numerous errors. Should archecker also work on level 1 backups? Upon request I can paste the archecker o…
HDR shutdown and Restart
Dears, Please let me know, if have HDR setup for PRIMARY AND SECONDARY and if we have to shutdown for patching activity both server then can we directly shutdown ( onmode -ky ) and then restart ( oninit -vy ) ? In this case if we start both servers directly thru oninit -vy then w…
Checkpoint duration and TXNS Blocked
Hello everyone, We are having problems with one of our servers. For a few days now, checkpoints that generally lasted 0 seconds are repeatedly taking 1 second, sometimes 2 seconds, and some transactions are being blocked. "21:11:18 Checkpoint Completed: duration was 1 seconds.…
select next rows
Hello All, How can I select Next few rows . e.g. SELECT FIRST 1000 * FROM emp ----> it will give me first 1000 record. But if I need next 1001 - 2000 rows , then how can I select in Informix 11.70? Kindly guide. Thanks Amit Patel ------------------------------ AMIT PATEL --------…
calculation of Required logical log
Hello All, We need to the data purging for table which is having huge data. We are renaming table with other table and then Re-creatingthe original table and from backup table again inserting data based on condition like "INSERT INTO cs_pmpt_regn SELECT * from cs_pmpt_regn_backup…
informix download
anyone has any Informix software download link version over 11.50 64 bit for personal use? kindly share/ Thanks Amit Patel ------------------------------ AMIT PATEL ------------------------------ #Informix…
Number of extents
Dears, We got issue for number of chunks exceed. Is this Informix bug or Informix can not read extent if over 200 extents? if we move the table in other dbspace where dbspace has much space left, will solve the problem without changing the table data and schema? Error Could not i…
Informix free versions - production site
Hello all, I would like to know what editions of IDS I can use for free in a production site. From what I heard, for that purpose I cannot use a Developer Edition, and the best option would be an Innovator Edition. So I would like to confirm that and also know more about these ed…
external table
Hello All, I've to create below external table for my testing , but while using IN DBSPACE clause I'm getting syntax error. Please let me know , where should I use this clause? CREATE EXTERNAL TABLE emps_ext01 ( emp_no INTEGER EXTERNAL char(10) , emp_name CHAR(10) EXTERNAL CHAR(1…
IDS 14.10.FC5 on Ubuntu 20.04 - can't start shm listener
Before I open PMR, does anyone have this problem: Normal installation, DBSERVERALIAS for shm connection: DBSERVERNAME ifxpri DBSERVERALIASES lo_ifxpri,ifxpri_shm sqlhosts with shm record: ifxpri onsoctcp 192.168.193.209 ifxpri lo_ifxpri onsoctcp 127.0.0.1 lo_ifxpri ifxpri_shm oni…
ontape, which sysmaster table(s) ?
Hi to All what are the sysmaster tables where we can find informations about "ontape" backups ? thanks in advance ------------------------------ John Smith ------------------------------ #Informix…
Looking forward with IBM Informix 2021 replay is now available
Thank you to everyone who joined today's call on the IBM Informix roadmap. The replay is now available in the Library under Webcast Replays: available here Carlton ------------------------------ Carlton Doe ------------------------------ #Informix…
Slow Running Query
Good morning All, Kindly le t me know , if I run " onstat -g act -r 2 " and get multiple rows with some RSTCB values , so how can we check which SQL causing to run slow query. Because it will be tough to check which RSTCB value is constant among multiple rows. Thanks Amit Patel …
Error converting data type DBTYPE_DBDATE to date.
We have two different servers one is SQL server 2005 another which we recently migrated to SQL Server 2019. Linked server query is running properly on sql server 2005.but issue in the SQL server 2019. it throws " Msg 8114, Level 16, State 10, Line 1 Error converting data type DBT…
[Informix][Informix ODBC Driver]Unspecified System Error = -21005
OLE DB provider "MSDASQL" for linked server "linkserver" returned message "[Informix][Informix ODBC Driver]Unspecified System Error = -21005.". Msg 7330, Level 16, State 2, Line 1 Cannot fetch a row from OLE DB provider "MSDASQL" for linked server "linkserver". it is running and …
issue with the ODBC Driver
We have SQL Server 2005 which has linkedserver created on it with informix ODBC driver through dsn datasource. Which is running properly. Currently we are migrating it to SQL Server 2019. After migrating,The linked server query is getting executed till 15th minute. After that dri…
Simple Large Object Replication
HI, I have a customer who wants to implement Informix Repication (not yet decided which kiind of). He is using lots of Simple Large Objects (Text). Taking into account the fact that TEXT data type are not replicated, he wants to know what is the best approach, storing them into d…
HDR
Hello all, I'm doing the HDR setup on my personal laptop with IDS 11.50(OLD ONE) for learning purpose. I created two server on VMWARE and did FIREWALL off and both server can ping to each other. I'm facing problem when I go to create 2ndary Server. I've attached the doc for the s…
in-place alter - get fields
Hello, Depending on what I saw here https://youtu.be/xsylAz5U1sY?t=1239 I ran this script for finding the unresolved in-place alter. SELECT dbsname, trim(owner) ||"."|| tabname AS fullname FROM sysmaster:systabnames t, sysmaster:sysptnhdr h WHERE h.partnum = t.partnum AND dbsname…
backup tables
Hello All, Kindly let me know , I have to drop 220 tables from production environment and each table around 1 million rows (300000). These table dropping is part of some activity so that day Backup will not run. Concern database has around 5K tables. So what type of backup should…
Things That Should Never Happen
Had a "fun" one today. We have a four-node cluster that features a primary, an HDR secondary (NEAR_SYNC mode), a regular RSS secondary and an RSS secondary with DELAY_APPLY=12H. The cluster is running a patched version, with three of the four nodes running 12.10.FC14XO but the pr…
Undocumented logical log flags
Hi, Could anyone advise on the logical log flags shown in this 'onstat -l' excerpt please? address number flags uniqid begin size used %used ... 17d9074a0 1720 URB---- 2400038 261:45678595 65536 65536 100.00 17d907508 1721 URB---- 2400039 261:45744131 65536 65536 100.00 17d907570…
Authenfication
Hi to All on onconfig : i want to use two different authentification methods for the same server : OS USER and INTERNAL USER, is is possible ? DBSERVERNAME db_serv (OS USER) DBSERVERALIASES db_net (INTERNAL USER) on sqlhosts db_serv onsoctcp host_ip host_port_1 db_ne…
monitoring session memory
IDS 11.70FC4 I seem to be having some serious session memory leaks. Sadly it is intermittent. All the clients are using DBD::Informix (perl) to access the database. I have to run onmode -F quite frequently and restart some of the clients so it looks like something is not being cl…
Index page size recommendations
IDS 14.10.FC5 RHEL 8.2 Migrating from an older release of Informix on a different OS, so everything will be different in the new environment. New Informix, new OS, new hardware. So, this is a great time to consider changing some of the things that have remained in place for so …
DATABASE vs CONNECT TO: Invalid characters error?
Hello, Configuration: Platforms: Linux Debian 10.7 Informix server: IDS IDS-14.10.FC5 Informix client: CSDK 4.50.FC5 DB_LOCALE = en_us.utf8 CLIENT_LOCALE = en_us.8859-15 Can someone from IBM explain this? Depending on the usage of DATABASE or CONNECT TO, a PREPARE + EXECUTE produ…
ESQL/C: Fetching LVARCHAR with ifx_var_getdata() when DB and client locale do not match
Hello! Configuration: Platforms: Linux Debian 10.7 or Windows 10 Informix server: IDS IDS-14.10.FC5 Informix client: CSDK 4.50.FC5 DB_LOCALE = en_us.utf8 CLIENT_LOCALE = en_us.8859-15 (Linux) / en_us.1252 (Windows) We experience character encoding conversion issues when fetching …
Validate backup : archecker –tdsv and CommVault
Hello, I'd like to validate a backup with archecker ‑tdsv but in front of CommVault If i run it as is i get Error(2) opening tape device(/commv_dev/tmp0) On the same machine, a table restore with commvault works with this command Advanced Restore archecker -Xbvs -f cmdfile Does…
InformixHQ on Windows questions
SUSE Linux Enterprise Server 11 (x86_64) PATCHLEVEL = 4 IBM Informix Dynamic Server Version 12.10.FC7 Our ERP which uses Informix just released an upgrade to Informix 12.10.FC13 so would be putting an agent on that server once upgraded. We currently have OAT on a windows server t…
nb of extents ?? dbschema vs oncheck
Hi to All Can anyone help me to understand please :) , why extents sizes is differents between table schema and oncheck -pe ? 1/ pages per extent dbspace with page size = 8k table first extent : 32k means 4 pages, table next extent : 32k means also 4 pages 2/ The table { TABLE "u…
Unknown error message 966.
Howdy! I ran a SQL script, where I created a raw table as select statement, did so using isql from a client server, and I got this weird message where it should have said table created: Unknown error message 966. Any clue as to what might have happened? Thanks in advance. Ramón D…
onsmsync issue question
Guys: A client is trying to sync the onbar safety file and clean up sysutils with onsmsync . This message is printing in the onbar log repeatedly and the onsmsync has been running for nearly 12 hours already: 2021-01-29 08:50:31 33591 24208 dsm_obj.c:658 dsmMakeObjectCursorList:…
OpenSSL Bug in 14.10.xC5?
[UPDATE: No bug. PEBKAC error; bad file permissions were the culprit.] IDS 14.10.FC5 on CentOS 7 x86_64 We recently switched from using GSKit/CSM key databases to OpenSSL/p12 key databases. Since then, when running locally on the host where the DB resides, regular users can still…
database list under dbspace
Hello All, How can I select all database name under any dbspace thru SQL? I'm not getting any join conditions between sysdbspaces and sysdatabases. please suggest. Thanks Amit ------------------------------ AMIT PATEL ------------------------------ #Informix…
curious about extendable chunks
We're in the process of migrating to 14.10 from a version (never mind how old) that did not have storage pools. I attended sessions at IIUG about storage pool and the ability to automatically add space as a dbspace filled up. As I understood it at the time, it would do this by …
OS upgrade and Informix Server
Hi everyone! I have an Informix Server version 12.10.FC10WE running in a RHEL 6.5 machine, and we are planning to upgrade the OS version to RHEL 7.0. So, in order to do this OS upgrade, what would be the best option? Should I move the Informix Server to another machine and then u…
NETTYPE connections per thread
Hi all What is the impact of not having enough threads per connection. NETTYPE ipcstr,12,200,CPU VPCLASS cpu,num=12,noage,autotune=1,max=14. How do I know if I am getting up towards that limit. Regards Jason ------------------------------ Jason Ball ------------------------------…
Is there a way to check the sbspace usage by table?
Hello All, I want to know the usage of sbspace by table. In the case of BLOBspace, it is possible to check the usage for each table with the oncheck -pe command. ---- checking utilization for table using BLOBspace $ dbschema -d testdb -t mycatalog ... create table "informix".myca…
DIRECT_IO/KAIO
Hi Please give me an abstract of using these two parameters, on Linux and AIX What i know is that DIRECT_IO is recommended for coocked files (do not use KAIO) , but what about raw devices ? Thanks in advance for your knowledges ------------------------------ John Smith ----------…
Setting a user to Read only access
Hi, We have been asked by a client who is using IDS 12.10 to set a particular user to have read only access to the database. Just a bit of background - this is the user they will use to access the database using ODBC for reporting. The ODBC driver is a read-write driver. By defau…
Spot the difference
> onstat - IBM Informix Dynamic Server Version 14.10.FC4W1DE -- On-Line -- Up 10 days 04:18:20 -- 334828 Kbytes > > onstat - IBM Informix Dynamic Server Version 14.10.FC5DE -- On-Line -- Up 00:01:54 -- 185996 Kbytes 2020-12-22 18:08:01 > Is this feature or bug? Hrvoje -----------…
Slow running backup
Hello everyone, If the backup is running slow thru ontape command , how can we check that and what could be the reason for slow backup? And what could be the resolution? Thanks Amit Patel ------------------------------ AMIT PATEL ------------------------------ #Informix…
Smart Blob Metadata Queries?
Can anyone let me know how to determine the metadata defaults for an SBSpace in code? I know that I can get that from "onstat -g smb" but I want to be able to query the info using SQL or UDR API functions. Anyone? ------------------------------ Art Kagel -------------------------…