![]() You may query the systools.stmg_dbsize_info directly to get the results as well.ĭb2 "select db_size, db_capacity from systools.stmg_dbsize_info"ĭb2 "select db_size/1073741824 as SIZE_GB, db_capacity/1073741824 asĬAPACITY_GB from systools.stmg_dbsize_info" db2 "select db_size, db_capacity from systools.stmg_dbsize_info"ĭb2 "select db_size/1073741824 as SIZE_GB, db_capacity/1073741824 as CAPACITY_GB from systools. The database size and capacity will be recalculated immediately.ĬALL GET_DBSIZE_INFO(?, ?, ?, 0) Value of output parameters The below returns the database size and capacity using a refresh window of 0 minutes. If the cached values are not current enough, new cached values are calculated, inserted into the SYSTOOLS.STMG_DBSIZE_INFO table and returned, and the snapshot-timestamp value is updated. If there are values cached in the SYSTOOLS.STMG_DBSIZE_INFO table and they are current enough, as determined by the snapshot-timestamp and refresh-window values, these cached values are returned. The SYSTOOLS.STMG_DBSIZE_INFO table is created automatically the first time the procedure executes. ![]() The procedure caches these values because the calculations are costly. The calculated values are returned as procedure output parameters and are cached in the SYSTOOLS.STMG_DBSIZE_INFO table. Sanders should receive 4 Version 8 certifications before the first Version 8 book even hits the market.The GET_DBSIZE_INFO procedure calculates the database size and maximum capacity. He has written several computer magazine articles, authored a tutorial on Database Concurrency for IBM's DeveloperWorks web site, presented at three IDUG conferences, and is the author of seven DB2 titles (073842522, 0072133759 (best-selling all-in-one exam guide), 0071353895, 007353925, 0071345728, 0070580871, 007057725). He has been designing and programming software applications for IBM PCs for more than 15 years and he has worked with the DB2 Universal Database and its predecessors for the past 10 years. This study-guide walks you step-by-step through deployment planning database security SQL DB2 database object creation and management database. Roger Sanders is a Database Performance Engineer with Network Appliance, Inc. ![]() Written by a DB2 UDB Certified author who worked directly with the DB2 UDB Version 8.1 Certification Exam development team and. This book covers the second 'Fundamentals' exam (test 701) an individual needs to pass in order to become an IBM Certified Database Adminstrator. This is a must-have for any DBA taking the first certification exam. DB2 Universal Database V8.1 Certificaiton Exams 701 and 706 Study Guide. Exam-like questions and answers are provided at the end of each chapter and information explaining why each answer provided is correct accompanies every answer given. Written by a DB2 UDB Certified author who worked directly with the DB2 UDB Version 8.1 Certification Exam development team and reviewed by the IBM Data Management Certification Program Manager, each book is guaranteed to provide the reader with all of the information needed to pass the V8.1 Certification test 700. This edition applies to Db2 11 for z/OS (product number 5615-DB2), Db2 11 for z/OS Value Unit Edition (product number 5697-P43), and to any subsequent releases until otherwise indicated in new editions. This book covers the first "Fundamentals" exam (test 700 (previously test 516)) an individual needs to pass in order to become DB2 UDB Version 8.1 certified.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |