Discuss About Db2 Bind?

1.	Discuss About Db2 Bind?
Answer» The process that builds access paths to the DB2 table is known as bind. The bind USES Database Request Modules from the DB2 pre-compile step as INPUT and PRODUCES an application plan. It checks for user AUTHENTICATION and validates SQL statements in the DBRM(s). The process that builds access paths to the DB2 table is known as bind. The bind uses Database Request Modules from the DB2 pre-compile step as input and produces an application plan. It checks for user authentication and validates SQL statements in the DBRM(s).

Answer»

The process that builds access paths to the DB2 table is known as bind. The bind USES Database Request Modules from the DB2 pre-compile step as INPUT and PRODUCES an application plan. It checks for user AUTHENTICATION and validates SQL statements in the DBRM(s).

The process that builds access paths to the DB2 table is known as bind. The bind uses Database Request Modules from the DB2 pre-compile step as input and produces an application plan. It checks for user authentication and validates SQL statements in the DBRM(s).

Discussion

No Comment Found

Related InterviewSolutions

Mention The Downsides Of Page Level Lock?
Mention The Different Locking Levels That Are Available In Db2?
What Is Release/acquire In Bind?
Mention The Various Locks That Are Available In Db2?
Outputs Of Explain Are With Matchcols = 0. What Does This Signify?
Mention The Location Where The Output Received From Explain Statement Is Stored?
Before You Give The Explain Statement, What Are The Prerogatives?
What Is Meant By Explain?
Following A Db2 Update Statement, What Is The Quickest Way To Compute The Total Number Of Updated Rows?
In Case If At Some Point Of Time Db2 Is Down, Would That Impact The Pre-compilation Process Of A Db2-cobol Program?