- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Updating and sampling of catalog statistics for DB2 tablespace
The DB2 RUNSTAT utility records the details of tablespace, table, index, etc in the system catalog. The RUNSTAT generates the data like space available in table space, indexes, access paths, etc. We can use the below JCL step to update the catalog statistics of DB2 tablespace TABSPAC2 and to sample 25% of the rows.
//STEP1 EXEC DSNUPROC //UTPRINT DD SYSOUT=* //SYSIN DD * RUNSTATS TABLESPACE DBSET1.TABSPAC1 TABLE(ALL) SAMPLE 25 INDEX(ALL)
The SYSIN parameter can be used with RUNSTATS TABLESPACE statement followed by tablespace name qualified by database name.
- Related Articles
- How to create a DB2 Tablespace in storage group STG1 and bufferpool BP01?
- How to create a DB2 tablespace TABSPAC1 in the database DBSPAC1?
- How to reorganize the DB2 tablespace TABSPAC1 to reclaim fragmented space?
- How to create a DB2 segmented tablespace TABSPAC2 in storage group STOGRP1?
- Give the panel command to start a specific tablespace within a DB2 database.
- Sampling
- Reservoir Sampling
- Different Types of Sampling Techniques
- Updating MongoDB collection for _id?
- Application of Sampling Distribution Methods in Psychology
- Difference between Data Mining and Statistics?
- Investigation of root cause and resource responsible for the deadlock in DB2
- What are Sampling-Based Approaches?
- What is Statistics?
- Checking savepoint statistics of SAP HANA
Advertisements