Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
DB2 UDB Connection Overhead
We are running DB2 UDB for AIX V7.1. The tables in our Operational Data Store are updated with IBM's DpropR. We have about 30 subscriptions that process every 5 minutes. I've noticed that the monitor output shows about 150,000 connects per week. I'm assuming most of the connects are from... -
LIKE Predicte using HEX values
Does anyone know how to write a predicate that uses the LIKE clause to check for hex values? My SQL: select x,y,z from tablea where A like ????? the values I want to check for is a X'3F' Thanks -
IBM DpropR disaster
Has anyone created a disaster recovery plan for DpropR in a multi-server environment? We Capture data in 2 DB2/MVS subsystems and Apply it to multiple DB2/AIX databases and DB2/MVS subsystems. Our data recovery plan calls for the restore of subsystems / databases to a system quiesce or data...
