/****************************************************************************
** (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: insnap.C
**
** SAMPLE: Capture a snapshot at the instance level
**
** This sample creates an instance attachment, enables throttling
** for utilities and calls functions in utilsnap.c to capture an
** instance-level snapshot and print the monitor data.
**
** STRUCTURES USED:
** sqlma
**
**
*****************************************************************************
**
** For more information on the sample programs, see the README file.
**
** For information on developing embedded SQL applications see the Developing Embedded SQL Applications book.
**
** For 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 at
** http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp
****************************************************************************/
#include <sqlsystm.h>
#if (defined(DB2NT))
#include "utilsnap.cxx"
#else // UNIX
#include "utilsnap.C"
#endif
class InstanceSnapshot
{
public:
int GetInstanceSnapshot();
};
/***************************************************************************/
/* GetInstanceSnapshot */
/* Initialize the sqlma with values that tell the db2GetSnapshot API to */
/* capture an instance 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 InstanceSnapshot::GetInstanceSnapshot()
{
int rc = 0; // return code
unsigned int obj_num = 1; // # of objects to monitor
struct sqlma *ma_ptr = NULL; // sqlma structure pointer
unsigned int ma_sz; // size of sqlma structure
Snapshot snapshot; // Snapshot object
// 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)
{
cout << "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_DB2; // get db manager data
rc = snapshot.GetSnapshot(ma_ptr);
return rc;
} //InstanceSnapshot::InstanceSnapshotGet
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];
CmdLineArgs check; // command line arguments object
Instance inst; // Instance object
InstanceSnapshot instsnapshot; // Snapshot object
Snapshot snapshot;
// check the command line arguments
rc = check.CmdLineArgsCheck2(argc, argv, inst);
if (rc != 0) return rc;
cout << "\nTHIS SAMPLE SHOWS HOW TO GET AN INSTANCE LEVEL SNAPSHOT.\n";
// attach to a local or remote instance
rc = inst.Attach();
if (rc != 0) return rc;
// turn on all the monitor switches
rc = snapshot.TurnOnAllMonitorSwitches();
if (rc != 0) return rc;
// update UTIL_IMPACT_LIM parameter
rc = snapshot.UpdateUtilImpactLim();
if (rc != 0) return rc;
// capture a snapshot at the instance level and print the monitor data
rc = instsnapshot.GetInstanceSnapshot();
// detach from the local or remote instance
rc = inst.Detach();
return rc;
} // main