The first time you sign into developerWorks, a profile is created for you. Select information in your developerWorks profile is displayed to the public, but you may edit the information at any time. Your first name, last name (unless you choose to hide them), and display name will accompany the content that you post.

All information submitted is secure.

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

All information submitted is secure.

My developerWorks:

My notifications:

Sign out

Select a language:

DBA Central

Resources for IBM Information Management database administrators

Restricting database connections using trusted contexts in DB2 for Linux, UNIX, and Windows

Protect databases against unauthorized access or misuse by authorized database users. Learn to mitigate risks by ensuring that users are allowed to connect only from a list of trusted hosts known to be secure. More >

Featured content

09 Feb 2012 — Show descriptions | Hide descriptions

Migrating from DB2 Control Center to IBM Data Studio
Learn how to quickly transition from the soon-to-be deprecated IBM DB2 Control Center to IBM Data Studio 3.1, which was released in October 2011 with several enhancements to improve ease of use.
Managing and scheduling database jobs with the Data Studio Web Console
Use the new job management capability in IBM Data Studio for a simple, flexible way to create and manage database jobs, and to schedule command scripts to run automatically.
Real-time monitoring and more cool features in the new InfoSphere Optim Performance Manager V5.1 for DB2 for Linux, UNIX, and Windows
Explore new and updated features such as seamless analysis of performance data from real time to any time, enhanced SQL analysis, enriched reporting, in-depth connection analysis, and operation and usability improvements.
Finding and resolving IMS database exceptions using the Tools Base Administration Console for z/OS
Learn how the informational dashboard provides a starting point for viewing detailed database information. From the dashboard, view exceptions and use Administration Console widgets to verify the exceptions.
Scaling of DB2 for Linux, UNIX, and Windows memory-related configuration parameters on a test system
Use the included sample script to practice scaling the number of users and instance memory size, as well as the remaining parameters to realistically simulate a workload from a production system on a test system.
Using InfoSphere Optim High Performance Unload as part of a recovery strategy in an IBM Smart Analytics System
Learn the best practices for unloading, extracting, and repartitioning data in DB2 for Linux, UNIX, and windows databases. Using High Performance Unload, you can move large volumes of data quickly by reading directly from backup images or table space containers rather than relying on the DB2 software layer.
Effectively use DB2 data movement utilities in a data warehouse environment
Learn how to choose the proper data movement technique to efficiently move data between different systems in a large data warehouse. Explore a comparative study of the various methods for data movement.
Managing database connections with the IBM Data Studio web console
Learn how to use the web console to manage and share database connection information. This feature helps increase productivity among Data Studio users and reduce the overhead of tooling configuration.
Distributed DBA: Table movement made easy
With the help of DB2 9.7, learn how to move tables, indexes, long data, and large object (LOB) data from one table space to another using the ADMIN_MOVE_TABLE() procedure.
DB2 Basics: Demystifying table and table space states
Confused by messages you receive about DB2 table and table space states? Learn how DB2 for Linux, UNIX, and Windows uses these states to protect the integrity of the database, and how to respond to these messages.

Search technical library

All articles

All tutorials and online courses

Downloads, CDs, DVDs

Learning resources

Support

ISV Resources

More product information

Community

Close [x]

Help: Update or add to My dW interests

What's this?

This little timesaver lets you update your My developerWorks profile with just one click! The general subject of this content (AIX and UNIX, Information Management, Lotus, Rational, Tivoli, WebSphere, Java, Linux, Open source, SOA and Web services, Web development, or XML) will be added to the interests section of your profile, if it's not there already. You only need to be logged in to My developerWorks.

And what's the point of adding your interests to your profile? That's how you find other users with the same interests as yours, and see what they're reading and contributing to the community. Your interests also help us recommend relevant developerWorks content to you.

View your My developerWorks profile

Return from help

Close [x]

Help: Remove from My dW interests

What's this?

Removing this interest does not alter your profile, but rather removes this piece of content from a list of all content for which you've indicated interest. In a future enhancement to My developerWorks, you'll be able to see a record of that content.

View your My developerWorks profile

Return from help