View previous topic :: View next topic
|
Author |
Message |
rahul_sinha786 Warnings : 1 New User
Joined: 15 Jul 2006 Posts: 6 Location: Bangalore
|
|
|
|
Hi,
Suppose we fire any SQL query then what happened in Background Process.
Reply.....................
Bye |
|
Back to top |
|
|
rahul_sinha786 Warnings : 1 New User
Joined: 15 Jul 2006 Posts: 6 Location: Bangalore
|
|
|
|
Hi,
We are copiling a souce COBOL program which contains SQL code.After precompile System go down then BIND will work or not and why.
Reply.......................
Bye |
|
Back to top |
|
|
anamikak
New User
Joined: 10 May 2006 Posts: 64 Location: Singapore
|
|
|
|
The bulk of SQL execution takes place in the DB2 Database Services address space (ssnmDBM1), which contains these components: the Relational Data System (RDS), the Data Manager, and the Buffer Manager. The SQL travels through these three components before the results are returned to the application. The RDS passes requests to the Data Manager, which passes requests to the Buffer Manager. The results trace back from the Buffer Manager to the Data Manager to the RDS .wheather the Sql needs to pass throgh all the 3 layers depends on wheather the sql predicates ate type 1 or type2. |
|
Back to top |
|
|
red_roses
New User
Joined: 31 Oct 2005 Posts: 27
|
|
|
|
Rahul,
i dont see how you can relate the two posts. It would help if u put the topics separately,
the answer to ur second post.
Precompile doesnt need the data base, a pgm will pre compile even if the database is down. it only uses ur dclgen to validate ur sql statements etc
its only in Bind that actual acces is made to the database.
so if ur databse will go down, ur bind will fail, ur precompile wont. |
|
Back to top |
|
|
ravi17s Warnings : 1 New User
Joined: 15 Aug 2003 Posts: 57
|
|
|
|
Hi,
If the Precompile was Succesful, DBRM will be ready for ur bind.
Hence the Bind will be successfull, u can not execute the Program as there is no Load module.
Thanks,
Ravi.... |
|
Back to top |
|
|
Hanfur
Active User
Joined: 21 Jun 2006 Posts: 104
|
|
|
|
Ravi,
I agree that Precompilation would create DBRM.Now let us assume that
DBRM got created successfully and after that DB2 went down.I have a separate BIND card which uses this DBRM for my BIND. If DB2 is down do you think BIND would go successfully?
-Han. |
|
Back to top |
|
|
ravi17s Warnings : 1 New User
Joined: 15 Aug 2003 Posts: 57
|
|
|
|
Dear Hanfur,
If Db2 is down bind will not be successfull
The bind will fail RC=12 with the following message,
READY
DSN SYSTEM(DB2T)
DB2T NOT OPERATIONAL, RETRY COUNT IS ZERO
Thanks,
Ravi... |
|
Back to top |
|
|
red_roses
New User
Joined: 31 Oct 2005 Posts: 27
|
|
|
|
I see rahul has tried it out : ) |
|
Back to top |
|
|
Hanfur
Active User
Joined: 21 Jun 2006 Posts: 104
|
|
|
|
Ravi,
Quote: |
DBRM will be ready for ur bind.
Hence the Bind will be successfull,..
This caused a confusion ...
-Han. |
|
|
Back to top |
|
|
rahul_sinha786 Warnings : 1 New User
Joined: 15 Jul 2006 Posts: 6 Location: Bangalore
|
|
|
|
Hi,
Thanks for reply but its pretty confusing that someone saying that in my second post that Bind will work and some are saying not.
One thing i wou'd like to clr that both post r different no relation to each other
bye. |
|
Back to top |
|
|
Hanfur
Active User
Joined: 21 Jun 2006 Posts: 104
|
|
|
|
Rahul,
Bottom line is BIND require to have the avaialbity of DB2.If DB2 is down the BIND wont happen successfully..You dont have to get confused for this..
-Han |
|
Back to top |
|
|
|