![]() ![]() You can see that a lot of information is returned with this UDF. The following information is returned from this UDF: The new SYSPROC.ENV_GET_PROD_INFO UDF can be used to return information about the actual DB2 UDB product installed on your server. Use SQL to Get Details of the DB2 UDB Product Installed on Your Server The host name of my machine, the number of CPUs (both physical and enabled with a partition if you are using one), and total memory (in MB) is also shown. The results of this UDF tell me that I have my DB2 UDB server installed on a workstation that is running a 32-bit version of Microsoft Windows 5.1 (which is Windows XP technology) and I have installed Service Pack 1. The following figure shows an example of how to use this UDF: The total size of memory on the system (in MB) The number of configured physical CPUs on the system The total number of physical CPUs on the system This UDF returns the following information: The new SYSPROC.ENV_GET_SYS_INFO UDF returns information that relates to the server where your DB2 UDB product is installed. In this article, I will take you through the details of these new system information UDFs and give you examples of how to use them. These new routines are defined in sqlescat.h and placed in the new db2envinfo library located in the sqllib/bin/routine directory. If you already have an existing database and you have applied the maintenance stream for DB2 UDB V8.2.2 to your existing server, you can use the db2updt command to create these new routines. These new UDFs are created when a new database is created at the DB2 UDB V8.2.2 level. These news UDFs are added to an ever-expanding group of table functions that return information about the operations of your system (for example, you can use a table UDF to return snapshot monitor information). Before DB2 UDB V8.2.2, this information was only available via administrative APIs. Since the DB2 UDB V8.1 release, IBM has been working hard to expose more and more features through simple SQL that were once only invoked by a command-line or C API.ĭB2 UDB V8.2.2 adds three new user-defined functions (UDFs) that allow authorized remote clients to get details about a DB2 UDB server, including machine, product, and instance information, and so on. This involves yet another level of complexity.Īssuming that as a DBA you are neither a programmer nor someone who likes to use a GUI, what options do you have? The SQL API, which DBAs are typically well versed in, represents a common ground by which DBAs can leverage the productivity of a command-line environment–without the complexity. Suppose you had development skills in the Java language, for example you would have to use a JNI wrapper to call the C APIs provided by DB2 UDB. For example, if you want to get a snapshot of your database using a C API, you have to know how to programmatically call this API. This solves the problem of retrieving information from a graphical user interface (GUI), but involves programmatic or syntactical complexities. Sure, many of the utilities that DB2 UDB exposes for the retrieval of system information are based on a C API, or some sort of DB2 UDB CLP command. On the other hand, the typical method is not necessarily appealing either. Indeed, experienced DBAs tend to administer and maintain their databases using command-line scripts and so on. On the one hand, they can use graphical tools such as the DB2 UDB Control Center to help them, but many experienced DBAs do not like to use graphical interfaces. Traditionally, database administrators (DBAs) can get frustrated when trying to retrieve information about their database servers. This update was inspired by functional enhancements for SAP environments, but the reality is that everyone can benefit from the works that has gone into this update. The latest IBM DB2 version which currently running is 10.5 with the features of BLU Acceleration and its code name as 'Kepler'.In late April 2005, IBM released an update, called Version 8.2.2, of the IBM DB2 Universal Database product (DB2 UDB). In 1990, it was developed as a Universal Database (UDB) DB2 Server, which can run on any authoritative operating systems such as Linux, UNIX, and Windows. Initially DB2 was developed for specific platform of IBM. The name DB2, or IBM Database 2, was first given to the Database Management System or DBMS in 1983 when IBM released DB2 on its MVS mainframe platform. It is a Relational Database Management Syatem which is designed to store, analyze and retrieve the data efficiently.ĭB2 database supports Object Oriented features and non relational structure with XML. DB2 is a database server developed by IBM. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |