Latest Answer: 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 ...
Latest Answer: In certain circumstances, Informix can eliminate fragments from a search. When this occurs, system resources such as CPU cycles, cache buffers, and LRU queues are freed for other operations. Whether fragment elimination can occur depends on the form of ...
Latest Answer: from command line# onmonitor ->Logical-Logs->Databases
----- or ------
Following shell script, you can easily find out database name and in which
dbspace
#!/usr/bin/ksh
OUTPUT=lstdbs.out
TMPFILE=lstdbs.txt
PAGESIZE=2
BG=false
###############################################################################
if ...
Latest Answer: 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 ...
Latest Answer: sorrry. IBM has been releasing Iformix products ever since it took over Informix corp. ...
Latest Answer: 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 ...
Latest Answer: 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 ...
View page [1] 2 Next >>
Go Top
