Charles's Host Integration Server Ramblings - All Comments

re: WMI and Host Integration Server…

Charles Ezzell — Wed, 12 Aug 2009 17:49:33 GMT

Vijay,

Sorry for the delay, just saw that you had left a comment.

Take a look at the wmisnastatus.mof

file in the %snaroot% directory.

Status is defined as:

[read, values {"", "Inactive", "Pending", "Stopping", "Active" }, Description("The current status of the connection--Inactive, Pending, Stopping, or Active.") ]

uint32 Status;

while StatusText is defined as:

[read, values {"", "Inactive", "Pending", "Stopping", "Active",

"Incoming", "OnDemand", "OnDemandIncoming"}, Description("One of the status values.") ]

string StatusText; // one of the Status values

While they appear similar, there is a difference, as StatusText will indicate if this is an OnDemand Connection or not.

Granted, there is some inconsistency here, but internally there is a bit of a difference in what is returned for each. To be honest, I've not used the connection status that often, other than to display the StatusText value that is returned when testing. For example:

-----------------------------------

MsSnaStatus_Connection instance

-----------------------------------

InactiveState: 2

Name: PRINT

Status: 1

StatusText: OnDemand

-----------------------------------

MsSnaStatus_Connection instance

-----------------------------------

InactiveState: 0

Name: 3270D

Status: 4

StatusText: Active

On the 1st (Print), looking at the MOF, the inactivestate = 2 matches with "OnDemand". The status (1) matches "Inactive", which is true, and the StatusText value indicates again "OnDemand".

For the 2nd (3270D)

Inactive = 0, which can really be ignored since the connection is actually active (this might be a bug, not sure). Status = 4, which is "Active" and matches the StatusText. It is possible for the connection to have a Status of 4 and a StatusText of "incoming', depending on timing of the query. Personally, I would use Status or StatusText alone, not both.

Not sure if this helps, but hopefully.

Charles

re: WMI and Host Integration Server…

vijay_yadav@persistent.co.in — Wed, 05 Aug 2009 12:13:02 GMT

Hi Charles,

I have an doubt on WMI class property values.

The WMI class MsSnaStatus_Connection has two properties

1. Status and

2. StatusText

Q1. Why the data type of StatusText is string even it is having numeric value as 0,1,2,3,4 and 5. What value this class will display for StatusText (0 to 5 or description value in string)

Q2. What is the purpose of having Status field when we already have StatusText field. And how Status field is related with StatusText field.

Please provide your valuable input asap.

Regards,

Vijay

Charles s Host Integration Server Ramblings DB2 Code Page Fun | debt settlement program

Fri, 19 Jun 2009 17:06:27 GMT

PingBack from http://edebtsettlementprogram.info/story.php?id=22912

Charles s Host Integration Server Ramblings Performance Testing the | Insomnia Cure

Tue, 09 Jun 2009 01:34:11 GMT

PingBack from http://insomniacuresite.info/story.php?id=10473

Performance Testing the Microsoft OLE DB Provider for DB2 (Part 3) - Charles

DotNetShoutout — Thu, 04 Jun 2009 06:47:09 GMT

Thank you for submitting this cool story - Trackback from DotNetShoutout

Using PowerShell to Access DB2 | MS Tech News

Using PowerShell to Access DB2 | MS Tech News — Fri, 31 Oct 2008 14:57:41 GMT

PingBack from http://mstechnews.info/2008/10/using-powershell-to-access-db2/

infoblog » Importing CHAR() fields containing null values from DB2 to SQL Server via SSIS

Thu, 30 Oct 2008 19:31:41 GMT

PingBack from http://blog.a-foton.ru/index.php/2008/10/30/importing-char-fields-containing-null-values-from-db2-to-sql-server-via-ssis/