For more information about the site, see the
Keeping up with the latest and greatest DB2 updates
Cost vs. advantage of moving from IMS DB to DB2
DB2 and the fetch-first clause
Rollback changes coming undone
Freeing up OBIDs
What will be the impact of DB2 V8?
Date arithmetic in COBOL
Why deadlocks occur and what to do about them
Generating images of DB tables
Reducing DB2 batch windows
Running a 24x7 environment
Help with justification of BI investments
How to access DB2 from CICS or MS
Creating a DB2 trigger to execute a storage procedure
Making sure your I/O routine doesn't degrade performance
Using an open cursor to scroll forward and backward
Referencing additional columns in a DCLGEN
The role of the DBA
Traceroute utility report time
High risk credit card processing
Latest e-banking technology
POS vs. EDI
Chocolate chip? Oatmeal? Telling the difference between cookies
How does DB2 manage the memory allocations/deallocations in an AIX environment?
The logical data model
Console vs. GUI-based mainframe applications
Can you help me with this query?
Preventing SQL -904 (resouces unavailable) abends
Any word on when IBM will end support for DB2 V6?
Dropping EUL$ tables
Help with the 'in' clause
DB2 date conversion
DB2 mirroring: Tools and options for 24/7
Will the DB2 updates be committed as part of the two-phase commit?
I get a -30090 message when the CICS application is executed
Mainframe DB2 and stored procedure support
Dealing with SQL error codes
Converting words to numbers in DB2, and vice versa
Converting VSAM records into DB2
Two camps of opinion on tablespace allocation and index location
How can a stored procedure access a VSAM file w/o opening the file every time it's called?
I get a -407 on the call below. Could it be the OIBRNC column in table T2?
An explanation of BACKODUR, and why you shouldn't set it to zero
How to limit the number of records in a cursor using DB2 native SQL?
How can I reduce NLEVELS for an index?
Can we convert an app in TELON/IMS platform to a CICS/DB2 environment?
Data warehouses - for BI or operational systems data?
Can a search-condition in CASE expression contain a subselect?
Is it possible to run a one way datasharing system without the ICF?
Can I find out when an OMVS Dataset File or a Directory is changed?
How to write a query to search a field with just two characters?
Is running a reorg on indexes required?
What factors could affect DB2 batch performance?
Is it a good idea to migrate from IMS to DB2 in a z/OS CICS environment?
How can I find the DB2 version and release level info in my CICS program?
Can I expect CPU increases when converting apps from VSAM to DB2?
Any risks running a PL/I or COBOL program generated with the V7 SQL-Precompiler under DB2 V5?
Is a Coupling Facility needed to use DB2 Connect in a Sysplex?
Finding the 10 greatest numbers in a column
DB2 book recommendations for a COBOL/VSAM programmer
QMF versus SPUFI
Error trying to unload file with LOB column
Can I access table spaces from another DB2 in the same CPU?
DB2 versus Sybase
Tuning an access path using QMF
Analogous table of SYSIBM.SYSKEYS for DB2 7.1 on Windows
Accessing tables from another DB2 subsystem
How can I insert multiple rows in a DB2 table?
Can I define my cursor (the where part) after checking what fields have been populated and how?
An overview of normalization forms
Defining a cursor based on user-populated input fields
Question concerning nulls
Primary keys in DB2
How to prevent contention issues with batch and online programs with 24x7 availibility
Paging through DB2 records
Querying to get NULLs
Comparing DB2 and Oracle on different platforms for SAP
How can I access tables that were created by another user?
When do we need to reorganize a table? Part I
When do we need to reorganize a table? Part II
How to set up a CPU utilization system for production DB2 environment
Limiting the number of records in a SELECT statement
Formatting NATURAL_DATE strings
Using TRACKMOD NO in a tablespace definition
Equivalent DB2 syntax for the Oracle DECODE function
Backing up a database with SQL
DB2 versus SQL Server administrators
Error using FETCH ABSOLUTE in scrollable cursor
Illegal keyword in FETCH FIRST n ROW ONLY
Using VALUES IDENTITY_VAL_LOCAL()
Does the DEGREE(ANY) affect the data integrity?
Running DB2 and Oracle on the same server
Different date formats in CLP and Command Center
Multiplying fields from different tables
When not to have an index
Unix Systems Services, tools to work with DB2 for z/OS
State of EBusiness - Security
What are e-checks?