(Reginaldo Barosa) Without writing any Java code, you can build a three-tier Web application that uses servlets, JSPs, and Java, and accesses a DB2 database. Follow the steps and sample code in this article and learn how to use VisualAge Generator and WebSphere Studio to create, test, and deploy the
Community
INF: How to Monitor SQL Server 7.0 Blocking
The sp_blocker_pss70 stored procedure, described in this section, captures the following information: –The starting time (according to the computer that is running SQL Server) so that this sampling of blocking can be time-aligned with other performance information, such as a Microsoft Windows N
Creating NOT NULL Columns in Huge Oracle Tables
(Amar Kumar Padhi) Databases are often taxed by applying SQL statements to enormous tables. One such activity is when we add a new NOT NULL column with default value in a huge transaction table. By ‘huge’ I mean the number of records. I will discuss the addition of a new column with default valu
The Performance Diaries: Unlock the secrets of DB2 accounting and statistics reports
Many DB2 for z/OS and OS/390 DBAs don’t realize that DB2 monitor accounting and statistics reports contain a wealth of detail that can help with performance tuning. Accounting reports reveal information about application execution and statistics reports document activity at the subsystem level — tw
Maximum number of database users and roles that you can create
This article provides information about the maximum number of users and roles that you can create in SQL Server 7.0 and SQL Server 2000 databases. You can create a maximum of 16379 security accounts for a database. The maximum number of roles that you can create for a database is 16367.
Execution Plans
(G Vijayakumar) When I started using SQL Server, I was not using the “Show Execution Plan” properly to analyse the query. I always thought that when I compose a query, it is the best it can be; I never even think of performance on my query and I did not give much importance to looking at the “Execut
Understanding System Statistics
(Jonathan Lewis) What is the most important component of the Oracle Database engine? My vote goes to the optimizer. Everything the database does is SQL, and every piece of SQL has to be translated into something that can work efficiently. Whatever you do with your data, the optimizer gets involved.
IBM DB2 Migration Toolkit
You need to be able to access all of your information wherever it resides. DB2 Information Management software protects your current database investment and delivers information on demand to ensure your information is integrated, comprehensive, uniform, analyzable and accessible all the time across
XML and Dreamweaver
(Kevin Ruse) While certainly not a full-blown XML editor, Dreamweaver MX 2004 includes a fair amount of support for XML. This latest release eases the web designers’ transition into the area of structured markup. Many web designers using Dreamweaver rarely view their code, preferring instead to stay
FIX: SQLStatistics function returns incorrect sort order sequence
When you connect to Microsoft SQL Server 2000 or to Microsoft SQL Server 7.0, and you call the SQLStatistics ODBC function, you may notice that the collation is always returned as “A” regardless of the sort order sequence. You may also notice this behavior when you run the sp_statistics system st