(Rob Williams) When using SQL/PL you need to be careful about implicit truncation when using scalar function calls. DB2 developers write stored procedures to handle logic that is accessible to all applications. Often to protect against an SQL injection attack, as we discussed in previous blog entrie
Tag: IBM
Using PowerShell to Access DB2
(Charles Ezzell) Yes, PowerShell can be used to access DB2 using The Microsoft Host Integration Server Data Providers.
Simulate your business process using IBM FileNet Process Simulator
(Xiong Fei Pan and Gu Yi He) IBM FileNet Process Simulator is a fully integrated component of the IBM FileNet Business Process Manager (BPM) suite. Process Simulator can perform process simulation and what-if scenario analysis based on live or assumed data. Thus, you can discover how to remove bottl
Using SQL to search within a DB2 field on IBM i
(Kent Milligan) I am looking for an example of an RPGIV program that uses SQL to display within a subfile the results of a user query. I have searched the Web, and I find things that are almost but not quite what i am looking for. My program currently accepts a user input and displays a logical file
On Date Formats
(Craig Mullins) Regular readers of my blog know that from time to time I use the blog as a forum to answer questions I get via e-mail. Today, we address a popular theme – dealing with DB2 date data…
DB2 LUW Performance: Identifying Mosquito Swarms
(Scott Hayes) Congratulations on hunting your elephants. The prior blog post was the most popular ever; it has received well over 3,000 hits and continues to ascend in popularity. I readily concede that elephants can wreak havoc in your databases, but there exists a much more dangerous predator of y
IBM boosts information management range
(David Neal) IBM has made a number of announcements today around its information management solutions.
Top queries from a top session
(Chris Eaton) Two weeks ago I was at IDUG in Warsaw (a great conference this year with a lot of great sessions). I ended up delivering 4 sessions over the course of the week. Add in many customer meetings, some time working on the show floor and it was a packed week. One of the best sessions I atten
Enabling DB2 applications for HACMP Smart Assist
(Lakshmi Priya Kanduru) HACMP (High Availability Cluster MultiProcessing) is the IBM high availability solution for business-critical applications on AIX. It monitors applications and their resources for failures and automatically relocates them to another cluster node on failure to ensure high avai
We’re starting to talk about DB2 x for z/OS
(Willie Favero) We heard about at IDUG in Europe and we are hearing about at IOD 2008 here in Las Vegas this week. When I hear it two or more times, that tells me it’s OK for me to start talking about also.
