Hi. This is Jeff Podlasek with Toad DB2 development. In Toad for DB2 version 5.5, we have implemented several DB2 utility enhancements for both DB2 LUW and z/OS.
I've got Toad up and running. And on this first tab here, it's a database explorer. I've got DMQ tables being displayed. And now with Toad, you could right click, select Utilities, and generate reorg statements for MQ tables. In previous releases, this was not available for MQ tables, but it was available for regular tables. But the same dialogue comes up for reorging tables where you could specify your command options and very easily and quickly generate and execute reorg table statements for your MQ tables for DB2 LUW.
Also in our 5.5 release for DB2 on z/OS, you can now generate CHECK LOB statements. So for example, on this tab I'm connected to a DB2 z/OS version 10 subsystem. I've selected several table spaces, right click, and select Utilities, Check Lob. The Check Lob editor comes up, allows you to specify your command options. You have a general options. You can specify data set options. For example, if you want to generate a punch DDN statement, you could specify your data set template to be used for that punch and then very easily and quickly generate a script which will have the check LOB utility statements, along with any necessary template statements generated.
Also along the lines with DB2 for z/OS, you can very easily and quickly generate unload statements. This is new in our 5.5 release. You could select a table or table spaces, right click, select Utilities, and select Unload. The unload dialogue will display, allowing you to specify object level parameters as well as command level options, general options, advanced options, and data sets. By default these are populated by the default values for the utility. And you can very easily and quickly generate unload statements to unload your table spaces or specific tables for DB2 on z/OS.
Also along the lines with DB2 on z/OS, we now have support for unloading LOBS that are greater than 32 k in length. So if you have tables that contain large LOBS, you could select Utilities, Unload. And then part of the parameters for the command options is a keyword called spanned. If that is set to true, when we generate the unload statement we will generate the spanned yes clause in the statement, which will tell DB2, when it's running this utility, to actually unload the LOB values within the data set where all your data is stored for your unload data. So the span keyword handles LOBS greater than 32 k.