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!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. AS400Admin

    Poor Query Performance on my iSeries 270 @ V5R2???

    I found the discrepancy. OS400/DB2 does not return drive space back to the system when records are deleted. Rather, deleted records are marked as inactive and retained in the file until a RGZPFM is performed. The table in question had ~380,000 live records and 32 MILLION deleted. Therefore, my...
  2. AS400Admin

    Poor Query Performance on my iSeries 270 @ V5R2???

    I am relatively new to AS400 but I have been enlisted as my company's AS400 admin and DBA (I am already a SQL DBA). We have an iSeries 270 with max'd out hardware, and running V5R2. I have been reading redbook after redbook discussing the vast hardware performance improvements, and of course...
  3. AS400Admin

    AS400 Processors compared to INTEL?

    I am a new AS400 admin and I have begun a rather long reading list of redbooks. In reading about V5R2 and my iSeries 270, I realized that my hardest worked server currently has the slowest processors; dual 600Mhz, 4mb L2 cache, equating to 2350 CPW. I was both mortified and amazed. For a dual...

Part and Inventory Search

Back
Top