Tag: IBM

Community

Rapid application DB2

(Jonathan S Sayles) Learn how to use Enterprise Generation Language (EGL) — an IBM strategic fourth-generation language–to rapidly build enterprise-quality Web applications that access DB2 table data. We show the entire development process, from design through implementation, using a simple exampl

Community

Virtualize your data center with IBM DB2 Universal Database for Linux and Virtual Iron’s VFe — Flexibility and efficient resource utilization through hardware resource virtualization

Virtualization within the data center is a rapidly growing requirement for IT executives. Utilization levels need to be driven higher in order to reduce data center costs. Increasingly, IT organizations are moving away from implementing farms of standalone computers that perform dedicated functions

Community

Roll-Forward Recovery

(Roger Sanders) In the first column of this series, I described how information stored in a database’s transaction log files is used to return a database to a consistent and usable state after a system failure or program abend occurs. In the most recent column, I explained how backup images used wit

Community

TechTip: PREPARE to DECLARE

(Mike Faust) With the broad use of embedded SQL statements, sometimes it’s easy to overlook things that can substantially improve their performance. A great example of this is the use of prepared SQL statements in your embedded SQL code. Prepared statements improve performance by doing a portion

Community

Lock avoidance in DB2 UDB V8

(Werner Schuetz) During a table or index scan, DB2 Universal Database (DB2 UDB) normally locks each row that is scanned before determining whether the row qualifies for the query. Gain an understanding of how row locking works in DB2 UDB, and learn how you may be able to improve concurrency of scans

Community

Scheduling a SQL update statement

(Kent Milligan) I need to run a SQL update statement after hours, and it would be nice to schedule it. I saw your posting about the RUNSQLSTM command, but I’ve had no success with it. I tried saving my command in the STRSQL run, which it saved to a QSQLSESS file, but I still could not use that in th