/****************************************************************************
** (c) Copyright IBM Corp. 2007 All rights reserved.
**
** The following sample of source code ("Sample") is owned by International
** Business Machines Corporation or one of its subsidiaries ("IBM") and is
** copyrighted and licensed, not sold. You may use, copy, modify, and
** distribute the Sample in any form without payment to IBM, for the purpose of
** assisting you in the development of your applications.
**
** The Sample code is provided to you on an "AS IS" basis, without warranty of
** any kind. IBM HEREBY EXPRESSLY DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR
** IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF
** MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. Some jurisdictions do
** not allow for the exclusion or limitation of implied warranties, so the above
** limitations or exclusions may not apply to you. IBM shall not be liable for
** any damages you suffer as a result of using, copying, modifying or
** distributing the Sample, even if IBM has been advised of the possibility of
** such damages.
*****************************************************************************
**
** SOURCE FILE NAME: clisnap.c
**
** SAMPLE: Capture a snapshot at the client level
**
** This sample creates an instance attachment, and calls functions
** in utilsnap.c to capture an application-level snapshot and print
** the monitor data. Monitor data from the application-level
** logical data groups is unavailable if no applications are
** connected to the database being monitored.
**
** In order to access application-level monitor data, you must
** connect to the relevant database before you run this sample.
**
** DB2 APIs USED:
** db2GetSnapshot -- Get Snapshot
**
** STRUCTURES USED:
** sqlma
**
**
*****************************************************************************
*
* For information on developing embedded SQL applications see the Developing Embedded SQL Applications book.
*
* For more information on DB2 APIs, see the Administrative API Reference.
*
* For the latest information on programming, compiling, and running DB2
* applications, visit the DB2 Information Center:
* http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp
****************************************************************************/
#include "utilsnap.c"
int GetClientSnapshot(void);
int main(int argc, char *argv[])
{
int rc = 0;
char nodeName[SQL_INSTNAME_SZ + 1];
char user[USERID_SZ + 1];
char pswd[PSWD_SZ + 1];
/* check the command line arguments */
rc = CmdLineArgsCheck2(argc, argv, nodeName, user, pswd);
if (rc != 0) return rc;
printf("\nTHIS SAMPLE SHOWS HOW TO GET A CLIENT LEVEL SNAPSHOT.\n");
/* attach to a local or remote instance */
rc = InstanceAttach(nodeName, user, pswd);
if (rc != 0) return rc;
/* turn on all the monitor switches */
rc = TurnOnAllMonitorSwitches();
if (rc != 0) return rc;
/* capture a snapshot at the client level and print the monitor data */
rc = GetClientSnapshot();
/* detach from the local or remote instance */
rc = InstanceDetach(nodeName);
return rc;
} /* main */
/***************************************************************************/
/* GetClientSnapshot */
/* Initialize the sqlma with values that tell the db2GetSnapshot API to */
/* capture a client level snapshot. Then pass the sqlma to the */
/* GetSnapshot function in utilsnap.c, which captures the snapshot (using */
/* the db2GetSnapshot API) and prints the monitor data. */
/***************************************************************************/
int GetClientSnapshot(void)
{
int rc = 0; /* return code */
unsigned int obj_num = 3; /* # of objects to monitor */
struct sqlma *ma_ptr = NULL; /* sqlma structure pointer */
unsigned int ma_sz; /* size of sqlma structure */
/* determine and allocate the required memory for sqlma structure */
/* the memory allocated to ma_ptr is freed in the GetSnapshot function */
ma_sz = SQLMASIZE(obj_num);
ma_ptr = (struct sqlma *) malloc(ma_sz);
if ( ma_ptr == NULL)
{
printf("error allocating sqlma. Exiting.\n");
return(99);
}
/* initialize sqlma structure -- of significant importance here is the */
/* "obj_type" parameter, which indicates the categories of monitor data */
/* that will be collected */
memset(ma_ptr, '\0', ma_sz);
ma_ptr->obj_num = obj_num;
ma_ptr->obj_var[0].obj_type = SQLMA_APPLINFO_ALL;
ma_ptr->obj_var[1].obj_type = SQLMA_APPL_ALL;
ma_ptr->obj_var[2].obj_type = SQLMA_APPL_REMOTE_ALL;
rc = GetSnapshot(ma_ptr);
return rc;
} /* GetClientSnapshot */