To Toad for IBM DB2 community
Runstats for nicknames
Is it possible to add utility>runstat for nicknames in database explorer (like we have for tables)?
Tnx,
Ivan
Browse Recent Ideas
-
I agree
0 votes
This idea is active.Database Explorer »Add your comment for Idea: Runstats for nicknames -
I agree
1 vote
This idea is active.Database Explorer »Object explorer text in Upper-case
Add your comment for Idea: Object explorer text in Upper-caseObject explorer characters auto changed to upper-case or to upper-case in the search string. This is a minor annoyance in our team. Thank you
-
I agree
0 votes
This idea is active.Database Explorer »Add support for Admin Task Scheduler
Add your comment for Idea: Add support for Admin Task SchedulerI'd like to see support added for DB2's admin task scheduler, including add, list, update, get status, and remove tasks. I see this as a separate object in Explorer.
-
I agree
0 votes
This idea is in progress.Database Explorer »Data Compare Wizard for password change
Add your comment for Idea: Data Compare Wizard for password changeI have created a Compare Document. When my password changes on one of the databases, I get the error in the Compare document WITHOUT the chance to go through the Change Compare Wizard. That's harsh, I have to go through the wizard AGAIN.
Thanks, Tom Perkins, Simon Property Group, tperkins@simon.com
-
I agree
1 vote
This idea is active.Just something cool or urgent »Call Toad via command line to create a change script
I need to modify some tables, changing all LOB columns from NOT LOGGED to LOGGED, which can't be done with the ALTER statement. I can accomplish this through the Toad GUI, and it does a good job of creating the script to unload the data, drop and recreate the table and related objects, and reload the data. This takes a few minutes per table. The problem is that I literally have hundreds of tables that need to be changed. ...more »
Add your comment for Idea: Call Toad via command line to create a change scriptI need to modify some tables, changing all LOB columns from NOT LOGGED to LOGGED, which can't be done with the ALTER statement. I can accomplish this through the Toad GUI, and it does a good job of creating the script to unload the data, drop and recreate the table and related objects, and reload the data. This takes a few minutes per table. The problem is that I literally have hundreds of tables that need to be changed. I would love it if I could somehow call Toad via a line command, passing the necessary info like the table name, column name(s), what is to be changed, etc. and have Toad produce the scripts. This would save me many hours of navigating through the GUI. Is this possible?
« less full details »
-
I agree
2 votes
This idea is active.z/OS Management »Calculate Tablespace and Index Space
Add your comment for Idea: Calculate Tablespace and Index SpaceIt would be nice to have the ability to recalculate the necessary space for a tablespace or index based on the number of rows anticipated to be in a table. Currently, I use CAs space calculator.
-
I agree
1 vote
This idea is active.Editor »Code Completion for DB2 Nicknames
Add your comment for Idea: Code Completion for DB2 NicknamesHi, Toad Devs! I use DB2 nicknames for a lot of my work. I would suggest you implement code complete for DB2 nicknames. It would save me a LOT of time :)
Thanks,
Dean
-
I agree
2 votes
This idea is active.Just something cool or urgent »Schema Comapre Reporting too limited
Add your comment for Idea: Schema Comapre Reporting too limitedWhen you finish a Schema Compare, the only report you have is from the Print Preview. The information only counts differences.
I’m requesting an enhancement for a more robust report to do the following:
1. Report the actual differences and not just give you a count
2. Report the schema differences for more than one schema at a time
3. Some other ways to export the report other than Print | Preview
-
I agree
2 votes
This idea is active.Utilities »format timestamp in import wizard
Add your comment for Idea: format timestamp in import wizardcannot specify timestamp format for source file when using import wizard. currently have to do it from clp:
db2 "load from /db2/backup/load/test.txt of del MODIFIED BY COLDEL; timestampformat=\"yyyy-mm-ddhhmmssuu\" replace into db2admin.test"
it would be very good to have this as an option.
tnx
-
I agree
2 votes
This idea is active.Utilities »db2move support
Add your comment for Idea: db2move supportit would be nice to have db2move as an option beside import and export.
tnx
-
I agree
0 votes
This idea is active.Database Explorer »Android APP??
Add your comment for Idea: Android APP??What about an android app? With the use of tablets now all I need is a TOAD app and I can use the tablet to manage all my workload. Already use it for ssh to the servers.
-
I agree
1 vote
This idea is active.Database Explorer »Security problem. Disable 'save password' like oracle toad can.
Add your comment for Idea: Security problem. Disable 'save password' like oracle toad can.The ability to disable "save password" on the GUI.
Oracle toad can do this with an "RESTRICTIONS=P" during install.
Currently if administrator to the box simply copy someones "connections.xml" file in the documents and settings for that user and you will have all their database password info if they have used the "save password".
-
I agree
1 vote
This idea is active.Utilities »FTP Enhancment
Add your comment for Idea: FTP EnhancmentProvide optionson the format mode to use when FTP'ing files instead of defaulting to Binary ( i.e. add TEXT option)
-
I agree
3 votes
This idea is active.Database Explorer »z/OS Routines versioning support
Add your comment for Idea: z/OS Routines versioning supportI suggest you to add support of ALTER PROCEDURE/FUNCTION ADD/DROP VERSION and ALTER PROCEDURE/FUNCTION ACTIVATE VERSION ... operations in Database Explorer or routine editor form.
-
I agree
2 votes
This idea is active.Connections »Search for a database in Connection Manager
2 comments for Idea: Search for a database in Connection ManagerI would like to be able to search for a database or instance in Connection Manager.
-
I agree
3 votes
This idea is active.Utilities »Create Database model using Database Diagramm
3 comments for Idea: Create Database model using Database DiagrammIt would be nice to create a database model using the built-in Database Diagramm tool. Simply allow crafting of models using tables, views and FK/PK etc. A function to create the related SQL or even install the model would be of great help.
Additionally, it would be nice to allow modifications of existing data models using the Database Diagramm.
-
I agree
4 votes
This idea is in progress.Just something cool or urgent »DB2 LUW View Growth feature
1 comment for Idea: DB2 LUW View Growth featureProvide new features that support the capture, management and graphical display of historical space information for tables, indexes and tablespaces
-
I agree
1 vote
This idea is active.Database Explorer »Calculate Dimensions for Table with Blob
1 comment for Idea: Calculate Dimensions for Table with BlobI suggest you to add a feature to calculate the space for a table and an estimation of blob columns.
-
I agree
2 votes
This idea is active.Database Explorer »Code Relationship Diagram
2 comments for Idea: Code Relationship Diagram
Provide a graphical view of code relationships similar to the way Database Diagram provides a graphical view of table and view relationships so that code dependencies can be interpreted more accurately than the current text-based Dependencies tab.
-
I agree
2 votes
This idea is active.Utilities »Database Health Check
Add your comment for Idea: Database Health CheckProvide a reporting tool which reports and advises on various health aspects of LUW and z/OS databases including configuration, performance, storage allocation and clustering, etc.
-
I agree
0 votes
This idea is active.Just something cool or urgent »HADR improvements
1 comment for Idea: HADR improvementsHADR support seems to be poor and should be enhanced.
-
I agree
1 vote
This idea is active.Just something cool or urgent »pureScale
Add your comment for Idea: pureScaleAdd pureScale support
-
I agree
0 votes
This idea is active.Database Explorer »Cancel dialog that is being loaded
Add your comment for Idea: Cancel dialog that is being loadedAdd possibility to close dialog that is being loaded or hangs b\c of lock on system table(s).
Also it will be better to show not determined progress while its being loaded.
-
I agree
0 votes
This idea is active.Just something cool or urgent »Data search
Add your comment for Idea: Data searchFunctionality that will be searching through all selected tables or views for some specific information
-
I agree
0 votes
This idea is active.Just something cool or urgent »Mini game
Add your comment for Idea: Mini gameImplement mini game(s) something like Tetris inside the Toad
Social Web