DEFRAGMENT API

Posted in 2013

NATE HICKS — Fri, 15 Mar 2013 12:11:28 — source: IIUG Forums & Mailing Lists

Couple questions about the DEFRAGMENT API. How do you do indexes? Has anyone run into any issues with it? Can you make it run the indexes with the table?

↪ replying to NATE HICKS

Stuart Brooks — Fri, 15 Mar 2013 12:30:43 — source: IIUG Forums & Mailing Lists

Hi, Assuming you are using 11.70, it tells you in the information centre: http://publib.boulder.ibm.com/infocenter/idshelp/v117/topic/com.ibm.adref.doc/id s_sapi_107.htm To defragment an index, you must specify the partition number for the index, as in these two function examples: EXECUTE FUNCTION task("defragment partnum","2097154"); EXECUTE FUNCTION admin("defragment partnum","2097154"); To defragment a list of partitions, use either of the following functions: EXECUTE FUNCTION task("defragment partnum", "16777217,28477346"); EXECUTE FUNCTION admin("defragment partnum", "16777217,28477346"); HTH Stuart --- Ardenta Ltd is a company registered in England and Wales. Registered number: 4181041. Registered office: Saxon House, Downside, Sunbury on Thames, Middlesex, TW16 6RT. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of NATE HICKS Sent: 15 March 2013 12:11 To: ids@iiug.org Subject: DEFRAGMENT API [29755] Couple questions about the DEFRAGMENT API. How do you do indexes? Has anyone run into any issues with it? Can you make it run the indexes with the table? ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.