Table Repair without using JCL

Robert Krall

Table Repair without using JCL

Does anyone know if you can just repair table space without using JCL? I wanted to do via just a query tool like AQT or Toad. I dont think it's possible from reading documentation but thought I would ask the IDUG people before giving up hope.   Thanks for the help.

Philip Sevetson

Table Repair without using JCL
(in response to Robert Krall)
**please note my email address change**
Robert,

REPAIR is a DB2 utility command. If you need to run it using a SQL processor, check this documentation:
https://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/ugref/src/tpc/db2z_db2suppliedutsp.html

tl;dr
IBM-Supplied DB2 Stored Procedures allow users to run utilities via Stored Procedure calls. Your SQL processor must support those calls, and you must have privileges to run the stored procedure and the utility in question.

Philip Sevetson
Computer Systems Manager
450 West 33rd Street
New York, NY 10001
212-857-1688 w
917-991-7052 c
212-857-1659 f
[cid:[login to unmask email]

From: Robert Krall [mailto:[login to unmask email]
Sent: Friday, March 03, 2017 10:20 AM
To: [login to unmask email]
Subject: [DB2-L] - Table Repair without using JCL


Does anyone know if you can just repair table space without using JCL? I wanted to do via just a query tool like AQT or Toad. I dont think it's possible from reading documentation but thought I would ask the IDUG people before giving up hope. Thanks for the help.

-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
Attachments

  • image001.png (3.3k)