The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

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:

Managing pureQuery-enabled applications efficiently, Part 1: Set up an SQL management repository using an Ant script

Patrick Titzler (ptitzler@us.ibm.com), Solution Architect, IBM

Patrick Titzler is a Solution Architect in IBM Software Group, focusing on optimization of Java database applications with IBM Optim Solutions. He has many years of development experience, having contributed to various business intelligence and data warehousing products supporting DB2 for LUW and DB2 for z/OS. Patrick holds a Master's degree in Computer Science from the University of Rostock, Germany.

Soid Quintero (squinter@us.ibm.com), Technical Enablement Engineer, IBM

Soid Quintero is a co-op on the IBM Optim Solutions enablement team at the Silicon Valley Lab. She is currently working on her Master's degree in Human Factors and Ergonomics focusing on computer human interaction at San Jose State University in San Jose, California.

Summary: IBM® Optim™ Development Studio and the pureQuery Runtime include a command-line utility called ManageRepository that can be used to create, modify, export, import, and delete pureQuery metadata stored in the SQL management repository. Setting up an SQL management repository can be challenging using the ManageRepository utility command script. This tutorial shows you how to create and manage an SQL repository using an Ant script. You will also learn how to run the Ant script from within IBM Optim Development Studio.

View more content in this series

Date: 27 Jan 2011
Level: Intermediate
PDF: A4 and Letter (931 KB | 27 pages)Get Adobe® Reader®

Activity: 41794 views
Comments: