DB2 Tough Questions (2 of 4)

The utilities in DB2 are very useful, especially the LOAD utility. It allows you to easily transfer data between flat files and tables. Here are some questions about DB2 utilities:

Read my DB2 tough questions if you miss it.

DB2 is a growing and popular database. Developer and Admin or the roles you can do in DB2. But for each role, you need some special skills. Below are the key set of questions useful for your job.

How to the gym effectively at home to build your body and awesome fitness. Read more…

Q1) What is the NUMRECS option in the Load utility?

NUMRECS option in the Load utility gives the number of rows you are loading into a Table

Q2) What is LOAD PRESORTED in LOAD utility?

LOAD PRESORTED- You can use it if you know the data is presorted as per the clustering index

Q3) What is the FORMAT Internal option in the LOAD utility?

FORMAT INTERNAL option can be used for LOAD/UNLOAD. Normally this function will reduce usage of CPU time. So that performance will be improved. This is allowed in DB2v9 and V10. See syntax:

==>UNLOAD TABLESPACE DBB.TSS FORMAT INTERNAL

==>LOAD INDDN SYSREC REPLACE

FORMAT INTERNAL

INTO TABLE “SYSADM”.”TBB”

Q4) What is the PARALLEL option?

PARALLEL YES|NO – During REORG time, If you give parallel “yes”, it provides more efficient processing and reduced CPU usage. PARALLEL ‘No’ can be used if you have DASD constrained.

Srini

Data Engineer with deep AI and Generative AI expertise, crafting high-performance data pipelines in PySpark, Databricks, and SQL. Skilled in Python, AWS, and Linux—building scalable, cloud-native solutions for smart applications.