Hi Phil, When i'm trying to generate DDL for table-controlled partitioned table in AQT v.8.2.1 it is not giving me the PARTITION BY keywords. I have created it...
Hi Phil... I work in a PeopleSoft environment in DB2/zOS and in a single DB2 subsystem I have 5 PS databases with over 30,000 objects EACH. When I do a Compare...
I would like to take this opportunity to invite the AQT fans on this list to go update the AQT page on Wikipedia with the new features. It's against Wikipedia...
I've been tossed in the SQL Server pool (deep end). The AQT display is rather different from DB2; no extended column info, for example. I did a bit of work...
That's up to IBM. AQT doesn't have any internal hooks into the database, but only gets information that is available through the normal SQL interface. For...
There's no book that I would particularly recommend. I nornally use the manuals that come with SQL Server, then beyond that do a search on the web for whatever...
Didn't take long to run into problem(s). This is a client SQLServer/data, so I can't show too much. I don't have a SQLServer install; we do DB2. There are...
Thanks, this query has given us a lot of trouble, partly because it is possible to have a table with multiple partitioning indexes. If you look at the...
I'm not sure how much I can help you here. If you have access to the system tables (eg. dbo.sysobjects etc) then AQT should be able to show you all the objects...
Hi Phil, Doubleclick or F2, which normally opens a seperate content-window, disappears and is invisible. Complete Uninstall and Reinstallation does not help. ...
Just wondering, is there a way that we can tie back the application performance (hit ratio) for an application to a specific bufferpool in the monitoring tool?...
Hi, This happens from time to time. The window has somehow been moved of the screen. To fix the problem can you open "Registry Editor" (Start/Run/ type ...
To my knowledge this cannot be done. A bufferpool can be used by multiple applications, and each application can use multiple bufferpools, so it's a...
Hello. I am very new to AQT. So far, I think I'm going to like it; however, I am SQL challenged, so this is another learning curve. :) What I want to know is: ...
If you want to send the result of an AQT query to a user, then probably the best way to do this is to set up a batch script. With this you can run a query in...
Hi Phil, I guess i was not very clear. But i'm talking about a table controlled partitioned table on z/OS. In other words......there is no index at all !!! ...
A good point. This whole area is quite tricky. As far as I have been able to see, the info on the columns in the table-partition is held in catalog table...
Hi Kenneth, thanks to some info provided by an AQT user, I have now found the correct catalog tables/columns to query to get the partitioning columns. I'll...
Hi Phil, I have tried the cfg file you emailed me. I don't get the index partioning any more ..... wich is fine :-) But i don't get the partition keywords on...
Now that it matters :), it would be a Good Thing if the SQL Server display looked more like the DB2 one: include the PK column count with the main display,...
I can update the sqlserver2000.cfg and email it to you. I have added PK cols, plus support for generated columns. In terms of Extended Col info, what extra...
Phil: The revised config file would be welcome. I'm not likely to be in SQLServer for all that long, so figuring out its catalog.... For the Extended Col Info...
Thanks for the screen-shots - as the saying goes, a picture is worth a thousand words etc etc. Makes it a lot easier for me to see exactly what the problem is....
This is odd. In the latest cfg file I just changed the query that gets the partition columns. The partitioning values has not changed. Perhaps the best way to...
This SQLServer database has lots, so I get to look at them. But this view truncates, that is, no horizontal scroll bar (and may be no vertical) in the Text...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
