If you're looking for IBM Informix Interview Questions & Answers for Experienced or Freshers, you are at right place. There are lot of opportunities from many reputed companies in the world. According to research IBM Informix has a market share of about 1.6%. So, You still have opportunity to move ahead in your career in IBM Informix Development. Mindmajix offers Advanced IBM Informix Interview Questions 2019 that helps you in cracking your interview & acquire dream career as IBM Informix Developer.
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.
from command line# onmonitor ->Logical-Logs->Databases.
Informix IDS provide following modes:-
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.
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 the sometimes binary executable code is stored as a blob.
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.
An Informix instance is a single connection to shared memory. It is represented by one or more on 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.
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.
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.
Free Demo for Corporate & Online Trainings.