• No products in the cart.

Top 24 IBM Informix Interview Question & Answers updated 2022

1.What is a chunk in Informix?

A chunk is a physical portion of disk on which Informix stores its data. A chunk can be either a raw partition or a file system file. Informix suggests that a chunk’s name be a symbolic link to the actual chunk. For example, if you are using /dev/rdsk/c6t0d0s1 as a chunk, you could create a symbolic link named /dev/informix/chunk1 that points to /dev/rdsk/c6t0d0s1. That way, if there are ever any problems with that disk, you could replace the disk with another one and just change the symbolic link.

2.What is the option or command used in Informix for finding which dbspace a database resides?

From command line# onmonitor ->Logical-Logs->Databases.


3.Mention the database server operating modes available for Informix?

Informix IDS provide following modes:-
1)Online mode -> This is the normal operating mode of the database server.
2)Offline mode? -> The database server is not running. Shared memory is not allocated.
3)Quiescent mode -> This is the normal operating mode of the database server.
Administrators use this mode to perform maintenance functions that do not require the execution of SQL and DDL statements.
Only the administrator (user informix) can access the database
server.
4)Single-User mode -> This mode is an intermediary mode between Quiescent mode and Online mode.
?Administrators use this mode to perform any maintenance task, including tasks requiring the execution of SQL and DDL statements. Administrators can also perform all other functions available in Online mode. You can see the current database server mode by executing the onstat – utility from the command.

4.Who developed informix?

IBM releasing

5.What are the uses of key value locking in Informix?

The database server uses a concept called key-value locking to lock the deleted row. When the database server deletes a row, key values in the indexes for the table are not removed immediately. Instead, each key value is marked as deleted, and a lock is placed on the key value. One of the most important uses for key-value locking is to assure that a unique key remains unique through the end of the transaction that deleted it.

Without this protection mechanism, user A might delete a unique key within a transaction, and user B might insert a row with the same key before the transaction commits. This scenario makes rollback by user A impossible. Key-value locking prevents user B from inserting the row until the end of user A’s transaction.

6.What is Informix Binary Large Object?

A binary large object, also known as a blob, is a collection of binary data stored as a single entity in a database management system. Informix invented an alternative backronym, Binary Large Object. Blobs are typically images, audio or other multimedia objects, though sometimes binary executable code is stored as a blob.

Related Courses: IBM Netezza DBA

7.Who conceived and designed the Informix database management system?

The Informix database management system was conceived and designed by Roger Sippl in the late 1970s. Informix was founded in 1980, went public in 1986, and for a period during the 1990s Informix was the second most popular database system, after Oracle.

8.What is the Informix instance?

An Informix instance is a single connection to shared memory. It is represented by one or more init processes. When Informix is started or stopped, these processes appear and disappear. Informix used to use the term “server” when referring to an instance, hence the environment variable DBSERVERNAME.

9.Explain about light scans in Informix?

Light scans occur under the following conditions: The optimizer chooses a sequential scan of the table. The number of pages in the table is greater than the number of buffers in the buffer pool. The isolation level obtains no lock or a shared lock on the table: Dirty Read (including non logging databases) isolation level Repeatable Read isolation level if the table has a shared or exclusive lock
Committed Read isolation if the table has a shared lock.

10.What is the extent of Informix?

If a table is designed without specifying extent sizes, Informix uses a default of 16 pages for the first and 8 pages for each subsequent extent. Extent sizing is done when the table is initially created.

Related Courses: Tibco Spotfire

Develop your skills with >> Tibco BW  >>   Tibco iProcess Administration >>  Tibco CIM (MDM)

11.Somehow Informix fails to go online. Is there a way to view what oninit is doing?

Yes, you can start Informix in verbose mode:
oninit -v (this works on NT as well)
Informix will print everything that happens.
To close the verbose mode: start a second terminal session (UNIX) or command prompt (NT) and execute:
onmode -ky
N.B. Don’t close your terminal session (UNIX) or command prompt (NT) while in verbose mode. This will take Informix offline immediately.

12.I think I screwed up my onconfig file, and I do not have a backup of it. What should I do?

If Informix is still online, you can get a new onconfig with:
onstat -c >onconfig
If Informix is offline, you can retrieve the settings from the database with:
oncheck -pR
or
oncheck -pP 1 1

13.What is the informix-list@iiug.org mailing list?

The informix-list@iiug.org mailing list is a bi-directional gateway to
the comp.databases.informix (c.d.i) UseNet news group. Messages posted
to the news group are forwarded by mail to subscribers of the mailing
list; responses sent to the informix-list@iiug.org email address are
also posted to the news group; and the gateway manages to keep track of
things so that postings do not repeat themselves. The mailing list is
‘closed’ in that you cannot post directly to the list unless you also
subscribe to the list. However, you can always post to the news group
instead; that is fully open and unmoderated.

14.What Rules Exist Regarding Format, Content, Flame Wars, etc?

None; this is a news group! That is, there are no rules enforced by the
software. There are periodically discussions on c.d.i about what should
and should not be said. This is my FAQ, so it gets my spin on the rules
that should be followed.

  • Format: HTML postings are strongly discouraged; so are MIME
    postings. Both cause problems with many frequently used news
    readers. That means that attachments aren’t encouraged either.
    Also, sending the same information twice, once in HTML and once in
    plain text, is downright wasteful.

15.Can I ask about Perl, DBI and DBD Informix? Other products?

You may ask questions about Perl, DBI and DBD::Informix, but only if an
IBM or Informix database is involved, somehow — it is not a general
forum for arbitrary questions about Perl. However, there are
alternative forums that you should also use, described in the product.
However, those locations have changed over time, so you should be aware
of the official home, http://dbi.perl.org/, which contains pointers to
how to subscribe to the dbi-users at perl.org (anti-spammed) mailing
list. Note that (as of 2005-03-01 and v2005.01) the email address for
DBD::Informix support is dbd.informix at gmail.com (anti-spammed).

16.Mention the database server operating modes available for Informix?

Informix IDS provide following modes:-
1)Online mode -> This is the normal operating mode of the database server.
2)Offline mode? -> The database server is not running. Shared memory is not allocated.
3)Quiescent mode -> This is the normal operating mode of the database server.
Administrators use this mode to perform maintenance functions that do not require the execution of SQL and DDL statements.
Only the administrator (user informix) can access the database
server.
4)Single-User mode -> This mode is an intermediary mode between Quiescent mode and Online mode?
Administrators use this mode to perform any maintenance task, including tasks requiring the execution of SQL and DDL statements. Administrators can also perform all other functions available in Online mode. You can see the current database server mode by executing the onstat – utility from the command.

17.What is Informix Binary Large Object?

A binary large object, also known as a blob, is a collection of binary data stored as a single entity in a database management system. Informix invented an alternative backronym, Binary Large Object. Blobs are typically images, audio or other multimedia objects, though sometimes binary executable code is stored as a blob.

18.How does Informix use temporary dbspaces according to database logging mode, SQL statement WITH NO LOG, temp dbspace parameters settings, etc.?

Temporary tables in the server can be automatically routed to a dbspace. The DBSPACETEMP environment variable can be set to one or more dbspaces. If the DBSPACETEMP environment variable is not set, the server uses the value of the DBSPACETEMP configuration parameter. Temporary tables are fragmented across the dbspaces listed in either the environment variable or the configuration parameter. This occurs regardless of whether the query is a PDQ query or not.

If DBSPACETEMP is not specified, the temporary table is placed in either the root dbspace or the dbspace where the database was created. SELECT…INTO TEMP statements place the temporary table in the root dbspace. CREATE TEMP TABLE statements place the temporary table in the dbspace where the database was created.

19.Mention the three major components in Informix Dynamic Server on a UNIX system?

Shared memory, processes, disk space.

20.What can be used to capture an ISAM error from an Informix ODBC program on UNIX?

We can use the SQLCA structure to get the ISAM Error.
sqlca.sqlerrd[1] holds the ISAM error return code.
We can also use the target lmsg() and getmsg() library functions to obtain ISAM error message text.

21.What is Informix Universal Server?

Informix Universal Server was the brand name given to the 9.X versions of the product; the upgrade from the Informix Dynamic Server (IDS) 7.X products, skipping the XPS 8.X release numbers. The 9.X server contained a number of functional advances (data type extensibility, DataBladesetc), as well as improvements to the storage manager and SQL processing. The most recent versions of the Informix line — 10.X — are an evolutionary progression over the 9.X engine.

22.What is the size of the Informix page?

The most common page size used is 2KB, though some systems use a 4KB page.

23.Why does a foreground write in Informix decrease performance? State the reason for the same?

Foreground writes (FG) should always be zero. A foreground write is caused when a session needs to have a page from disk placed into the buffer pool, but there are no clean/free buffers available. In this case, the sqlexec thread will pick a page off the least recently used side of an LRU queue, write it out, and mark the page as clean. This process is time consuming for a session and should be avoided.

24.What is mirroring in Informix?

Mirroring is the process of replicating a dbspace for the purpose of reducing the risk of data loss in the event of a hardware failure. When mirroring is in place, both the primary and the mirror chunks are written to automatically. If a hardware failure causes the primary chunk to be inaccessible, Informix automatically reads from the mirror chunk.

© ZxAcademy - 2022. All rights reserved.