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.
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
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
…