Strange behaviour of syssqlhosts

Posted in 2015

Topics: Networking & sqlhosts Configuration

KHURRAM SHAHZAD — Sat, 25 Apr 2015 06:33:22 — source: IIUG Forums & Mailing Lists

Hi, I am using syssqlhosts SMI table in my query and a strange behavior observed on instance level, that is when I query on this table by using server name in where clause a new sqlhost file opens against the pid of aio process. But after execution of query all opened sqlhosts files are not closing. Regards, Khurram Shazad.

↪ replying to KHURRAM SHAHZAD

WOLFGANG EPPLER — Thu, 30 Apr 2015 10:48:04 — source: IIUG Forums & Mailing Lists

Hi, can you give more details please ? Version ? Platform ? Sample Query ? Thanks, Wolfgang

Glossary

sqlhosts