DB Dummy|Sharing Experience on Oracle & Informix Databases …

Sometimes you like to find out the hostname/IP address the sessions that came from.

onstat -g ses only display 8 characters out the hostname.

Use below query to retrive the hostname direct from sysmaster database :-

# dbaccess sysmaster –

SQL> select sid, username, hostname from syssessions where sid=session_id

I was getting error “shmget: [EEXIST][17]: key 52b14804: shared memory already exists” in online log and I notice OS physical memory and kernel parameters (shmmax) have much more available memory. But Informix instance unable to allocate new shared memory virtual segment during run-time from OS kernel. I notice there is no AF file (Assert Failed) generated.

I have raised a case to IBM Informix and confirm it was encountering IDS bug with product defect number  idsdb00206627.

Steps:

(1) Get TBLspace partnum using DBspace number.