If you get this exception, it most probably means that you’ve exhausted the max connections on your server. You can either increase the max connection, or change your thread pool …
Recently I ran into a couple of database issues that made me realize that I often take these operations for granted. Here are two snips that I wrote up on …
Recently I did a dbexport of our informix database for our client, but when they tried to load that table into their database, there was an error on trying to …
Recently I was working on an unrelated issue and I noticed that there was no foreign key constraint on a relationship that I thought obviously should have one. I decided …
Isolation level The default isolation level is based on whether or not the database has transaction logging enabled, and whether or not it is ANSI-compliant. The info in this link …
The dbexport and dbexport commands are described in migration.pdf dbexport Usage: dbexport <database> [-X] [-c] [-q] [-d] [-ss] [{ -o <dir> | -t <tapedev> -b <blksz> -s <tapesz> [-f <sql-command-file>] …
I lost my informix foreign key constraint Informix database isolation level Informix serial8 not the behaviour I expected SQLException: Cannot create a user thread dbexport and dbimport command usage IBM …