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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by AIXDB2DBA
-
Find table record length
The results in the following query do not reflect the same record length displayed in Control Center, Estimate Statistics panel in UDB AIX. Why? How could I build a query that generates record length for every table? select tabname,sum(length) from syscat.columns where tabschema =... -
Find table record length
The results in the following query do not reflect the same record length displayed in Control Center, Estimate Statistics panel in UDB AIX. Why? How could I build a query that generates record length for every table? select tabname,sum(length) from syscat.columns where tabschema =... -
Where could I find a table record lenght in the SYSIBM
The results in the following query do not reflet the same record lenght displayed in Control Center, Estimate Statistics panel in UDB AIX. Why? How could I build a query that generate record lenght for every table? select tabname,sum(length) from syscat.columns where tabschema =... -
UDB 5530 error message on Commit
We have been getting the following error message on Commit statements; Any ideas??? error 5530 - The commit processing of table "ITCPROD.WH_ADJ_ORGI_DEST_1" that used NOT logged initially has been initiated. It is recommended that you take a back up of the table's tablespaces(s). WE do daily... -
Where could I find a table record lenght in the SYSIBM
How could I do it for all table with a query? -
Where could I find a table record lenght in the SYSIBM
Where could I find a table record lenght in the SYSIBM in catalogs? I look into systables and is no there. -
Where to find table record lenght in SYSIBM for UDB DB2
Where could I find a table record lenght in the SYSIBM catalog tables? I look at SYSIBM.SYSTABLES and is NO there. -
sqlcode -2219
I getting an sqlcode -2219 with an error code 5590 when I schedule reorgs. What is this about?
