- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
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
How to reorganize the DB2 tablespace TABSPAC1 to reclaim fragmented space?
The tablespace reorganization is used to reorganize the data present in the system in order to reclaim the free space. This free space can be utilized to store the new data and therefore reorganization is very useful from a memory utilization point of view. We can reorganize any tablespace using DB2 REORG utility in JCL step as below.
//STEP1 EXEC DSNUPROC,UID='IUJLU101.REORG', //UTPRINT DD SYSOUT=* //SYSIN DD * REORG TABLESPACE (DBSET1.TABSPAC1) //*
The REORG TABLESPACE statement is followed by the name of the tablespace which needs to be reorganized qualified by dabasebase.
- Related Articles
- How to create a DB2 tablespace TABSPAC1 in the database DBSPAC1?
- How to Reclaim your Smart Phone’s Storage Space Quickly
- How to create a DB2 segmented tablespace TABSPAC2 in storage group STOGRP1?
- How to create a DB2 Tablespace in storage group STG1 and bufferpool BP01?
- Give the panel command to start a specific tablespace within a DB2 database.
- Updating and sampling of catalog statistics for DB2 tablespace
- How to recover a DB2 table space TABSPC1 using the image copy TOLASTCOPY?
- How to monitor temporary tablespace usage in Oracle?
- Reorganize String in C++
- How to provide & remove user access to/from DB2 object? Give the DB2 commands?
- How to get the list of all COBOL-DB2 programs using a DB2 table TAB1?
- How to check total space and available space in Linux using the terminal?
- How to precompile a COBOL-DB2 program?
- How to delete a DB2 table TAB1?
- How to delete all the DB2 packages in collection COLL1?

Advertisements