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:

Information Management

Technical resources for IBM Information Management software

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 >

Tabs showing featured content, developer and DBA links, and key topics

Featured content- selected tab,
Data Mgmt magazine
Developers
DBAs

09 Feb 2012 — Show descriptions | Hide descriptions

De-identify flat files and delimited files using InfoSphere Optim Data Privacy Solution and InfoSphere Federation Server
Mask data in files that could be part of a testing scenario. Using this article updated to include delimited files, learn how to de-identify data, create a relational table, and then apply data privacy algorithms.
Designing an integration landscape with IBM InfoSphere Foundation Tools and Information Server, Part 1
Use IBM InfoSphere Blueprint Director to depict a solution landscape and to provide guidance for subsequent project tasks. The series focuses on updating a Data Warehouse-Business Intelligence information process.
Developing heterogeneous database applications using the IBM Data Server Provider for .NET
Learn how to use the IBM Data Server Provider for .NET to create and manage global transactions on the IBM data servers using the code examples in this article.
Codepage conversion customization in z/OS
Use the examples in this article to learn how to customize a code page to support the transfer of characters in different languages from the mainframe side to the distributed side, and vice versa.
Download: Loading data with the IBM Informix TimeSeries Plug-in for Data Studio
Easily load data from an input file into an Informix table with a TimeSeries column by using IBM Informix TimeSeries Plug-in for Data Studio.
Designing a database for multi-tenancy on the cloud
Learn some database considerations that new SaaS vendors need to take into account when developing applications or modifying existing ones to enable multi-tenancy on the cloud.
Optimize InfoSphere DataStage jobs with Netezza Connector using DataStage Balanced Optimization
Rewrite a DataStage job to enhance performance by sharing or redistributing a processing load. Also learn about Netezza Connector features such as Action Column, Temporary Work Table, and Unique Key Column.
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.

Current issue and archives

Recognizing developerWorks Contributing Author: Serge Rielau
Serge's focus areas include SQL compiler technology and competitive migrations from Oracle and Microsoft SQL Server to DB2 for Linux, UNIX, and Windows (LUW). Serge joined the IBM Canada Lab - Toronto Site in 1998 after a year at the Almaden Research Lab, where he got started with DB2. Over the years, as a team lead and first-line manager, he worked on the DB2 LUW SQL front-end compiler, implementing various DB2 features such as "generated columns" and what's come to be known as the "new SQL," which enables people to select from insert, update and delete operations. He is now leading the DB2 push to become Oracle compatible. He has helped convert numerous independent software vendors and customers from Oracle and SQL servers to DB2. He has presented or placed papers at the International Conference for Very Large Databases (VLDB), the Special Interest Group on Management of Data (SIGMOD), the International Conference on Extending Database Technology (EDBT), the International DB2 User Group Conference (IDUG), and the IBM conferences CASCON, IM Tech, and Information on Demand (IOD). He has also obtained numerous patents in the field of relational technology. Visit his blog or wiki or follow him on Twitter @srielau.

See all of Serge's developerWorks content.
See Serge's developerWorks profile.

Products

Key topics

Downloads

Learning resources

Support

Support by family/product

Information Management support overview

Community

Recent forum topics

InfoSphere Information Server
Topic: IS-CDC a question about conversion...
by samlowry63, Feb 13 09:00 AM

Cognos BI 10
Topic: Creating Uneven Hierarchies in Framework...
by Stephan1981, Feb 13 08:50 AM

Cognos BI 10
Topic: Creating Uneven Hierarchies in Framework...
by Stephan1981, Feb 13 08:49 AM

Cognos 8
Topic: You can only perform this...
by GuruReddy, Feb 13 08:36 AM

DB2 for z/OS forum
Topic: DB2 Crossloader via TCP/IP
by ToddBurchDB2, Feb 13 08:21 AM

DB2 pureXML
Topic: Functions on XML
by eduardok, Feb 13 07:29 AM

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