Tracing Locks in Table level on informix

Tracing Locks in Table level on informix

# Find out the hex partnum number of the table

dbaccess sysmaster –
select hex(partnum),owner from systabnames where tabname=”table_name”;

example
=======

> select hex(partnum),owner,dbsname from systables where tabname=”country”;

(expression) owner dbsname

0x004004E5 grefdev gref420_cit3

1 row(s) retrieved.

Continue reading Tracing Locks in Table level on informix »

How to use Visual Block in gvim if Ctrl-V doesn’t work?

How to use Visual Block in gvim if Ctrl-V doesn’t work?

In higher version of gvim (example gvim 7.x), Ctrl-V will not work as Visual Block, but it is for pasting text.

These are the steps to resolve visual block, instead of Ctrl-V:

1. Press “Esc”.
2. Move cursor to the desired starting block.
3. Press “Ctrl-Q”, then release.
4. Hold “Shift” key while moving cursor to ending block, then release.
5. press “Y” to yank.
6. Move cursor to new position and press “P” to paste.

Here is the example to copy vertical blocks for “3” and paste to new line.

Before:

12345
12345
12345

After:

12345
12345
12345
3
3
3

Note: You may download Vim or gVim at:

http://www.vim.org/download.php

Informix – Compress data rows in a table

Given (IDS 11.50),
Database : testdb
table : cust_comp
owner : hello

(1) Before Compression

$ oncheck -pt testdb:hello.cust_comp

TBLspace Flags 801 Page Locking
TBLspace use 4 bit bit-maps

Number of pages allocated 90209
Number of pages used 87877
Number of data pages 86743
Number of rows 2949120

Continue reading Informix – Compress data rows in a table »