|
February, 2003
In
This Issue
|
|
All articles have been reprinted with the written consent of their respective authors. | |||||||||||||
|
|||||||||||||
|
PL/Generator PL/Generator is a generator engine that generates production-ready code written to your coding standards. It combines best-practice coding and sophisticated "database-aware" technology to generate table packages written specifically for your Oracle tables and to your specifications. PL/Generator employs plug-in drivers, each of which generate different source code as output. The PL/SQL Table Encapsulation Driver generates PL/SQL encapsulation packages for tables that can be compiled and deployed in production applications without any changes. Click Here for the program. |
|||||||||||||
|
|||||||||||||
|
Oracle 8I Row Chaining and
Migration In Oracle we sometimes come across poor performance in databases. Though there may be several reasons for low performance, you can prevent some of them by properly designing and/or diagnosing the database. Row Migration (RM) & Row Chaining (RC) are two potential problems that can be prevented. By suitably diagnosing RM/RC, you can improve database performance. Click Here
for the paper. |
|||||||||||||
|
|||||||||||||
|
Go Ahead, COMMIT On a Read COMMITing in a read-only situation releases locks and sets your application free. Many people working with DB2 for z/OS or OS/390 believe that it's not necessary to COMMIT on a read-only access. These folks think that because they haven't changed any data, the COMMIT is unnecessary. But COMMIT does more than simply apply changes; it also releases locks and claims. So COMMIT affects application availability. I'll explain the availability considerations of introducing a COMMIT in an application doing read-only access and the concepts of claims and drains. The examples I'll use are specific to read-only environments; they're not designed to cover COMMIT considerations with regard to update activity. The scope of this article is limited to COMMITs for read-only application programs in an environment that may include execution of utilities and other applications doing updates. In this article, I'll use the term "application availability" to mean availability with regard to permitting read access. Click
Here for the paper. |
|||||||||||||
|
|||||||||||||
|
Utility to Change Database Links This is a small script that logs on to the database, checks if there are any links that use the specific password. The information is then spooled, the script logs in as the owner of the link, drops the database link and recreates it. It then tests the database link and sends a mail out to the DBA. Click Here for the procedure. Utility to Check Database Links This utility is a handy one to check all the private database links that exist in the database under different users. This script checks all the private database links available, identifies the user who owns the database links and connects as owner of the database link and tests the link for connectivity. It then spools the information and mails to the mailing address specified. Click
Here for the procedure.
|
|||||||||||||
|
|||||||||||||
|
Manage Multiple SQL
Server Installations and Databases with OSQL At one point in time I was tasked with running over 70 databases on more than a dozen servers without any of the costly third-party tools that exist to accomplish such tasks and I often get asked how can you handle such large numbers of databases. This is a small article that will show you how to use the handy OSQL command line utility provided with SQL Server to execute repetitive tasks against large numbers of databases or manage large numbers of servers. The OSQL command line utility allows you to execute Transact-SQL statements, system procedures, and script files against multiple servers and databases by using ODBC connections to those servers and databases. The syntax of the OSQL utility allows you to specify which server, database, login, password, input file, output file, as well as formatting functions you want to run with your SQL script. By creating a small bat file containing this information for the servers and database you manage and creating a SQL script file, you can easily perform repetitive SQL tasks with one or two mouse clicks. Click
Here for the paper. |
|||||||||||||
|
|||||||||||||
Building quality steps in the workplan adds a certain amount of effort and cost to the project. Organizations and projects need to understand that these activities are an investment that they make to build quality solutions. These activities need to be accounted for in the budget and workplan for projects – especially large ones. Click Here for tips and techniques on
The Cost and Benefit of Quality. |
|||||||||||||
|
|||||||||||||
| Free
e-Seminars For detailed information on these free e-Seminars, please visit our News and Events page.
|
|||||||||||||
|
|||||||||||||
|
|||||||||||||
|
|||||||||||||
|
Interactive Crossword
Puzzle: "U.S. Presidents"
|
|||||||||||||
|
|||||||||||||
We love getting white papers, tips, articles, and code examples/archives from our readers around the world. Send your submission to newsletter@quest-pipelines.com. If your article is published, we will mail you a FREE gift from Quest as a gesture or our appreciation. Our mission at Quest Software - RevealNet Labs is to anticipate the daily responsibilities and challenges faced by database professionals. Our products help thousands of people solve problems and implement solutions every day. This newsletter is designed to help facilitate the sharing of information among database professionals. It is currently circulated to 28,000 readers. About the Newsletter This newsletter is distributed to Quest Software - RevealNet Labs customers, prospects and friends who have subscribed to it from our website. If you would like to unsubscribe, please send a note to unsubscribe@quest-pipelines.com and we will make every effort to remove you from our list. Subscribe a Friend! Do you know someone who would like to receive the Pipeline Newsletter? If so, please enter their email address in the box below and click SUBMIT.
Past Issues of the Pipeline Newsletter |
|||||||||||||
