Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
DB2 Background Process

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
rahul_sinha786
Warnings : 1

New User


Joined: 15 Jul 2006
Posts: 6
Location: Bangalore

PostPosted: Sat Jul 15, 2006 10:59 pm    Post subject: DB2 Background Process
Reply with quote

Hi,

Suppose we fire any SQL query then what happened in Background Process.

Reply.....................



Bye
Back to top
View user's profile Send private message

rahul_sinha786
Warnings : 1

New User


Joined: 15 Jul 2006
Posts: 6
Location: Bangalore

PostPosted: Sat Jul 15, 2006 11:01 pm    Post subject: DB2 Bind
Reply with quote

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
View user's profile Send private message
anamikak

New User


Joined: 10 May 2006
Posts: 64
Location: Singapore

PostPosted: Tue Jul 18, 2006 10:00 pm    Post subject:
Reply with quote

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
View user's profile Send private message
red_roses

New User


Joined: 31 Oct 2005
Posts: 27

PostPosted: Tue Jul 18, 2006 11:24 pm    Post subject:
Reply with quote

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
View user's profile Send private message
ravi17s
Warnings : 1

New User


Joined: 15 Aug 2003
Posts: 57

PostPosted: Wed Jul 19, 2006 5:27 pm    Post subject: Re: DB2 Background Process
Reply with quote

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
View user's profile Send private message
Hanfur

Active User


Joined: 21 Jun 2006
Posts: 104

PostPosted: Wed Jul 19, 2006 5:33 pm    Post subject: Hi
Reply with quote

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
View user's profile Send private message
ravi17s
Warnings : 1

New User


Joined: 15 Aug 2003
Posts: 57

PostPosted: Wed Jul 19, 2006 8:45 pm    Post subject: Re: DB2 Background Process
Reply with quote

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
View user's profile Send private message
red_roses

New User


Joined: 31 Oct 2005
Posts: 27

PostPosted: Wed Jul 19, 2006 8:57 pm    Post subject:
Reply with quote

I see rahul has tried it out : )
Back to top
View user's profile Send private message
Hanfur

Active User


Joined: 21 Jun 2006
Posts: 104

PostPosted: Thu Jul 20, 2006 12:04 pm    Post subject: Hi
Reply with quote

Ravi,

Quote:
DBRM will be ready for ur bind.
Hence the Bind will be successfull,..

This caused a confusion ...

-Han.
Back to top
View user's profile Send private message
rahul_sinha786
Warnings : 1

New User


Joined: 15 Jul 2006
Posts: 6
Location: Bangalore

PostPosted: Sun Jul 23, 2006 10:56 pm    Post subject: Re: DB2 Background Process
Reply with quote

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
View user's profile Send private message
Hanfur

Active User


Joined: 21 Jun 2006
Posts: 104

PostPosted: Mon Jul 24, 2006 12:23 pm    Post subject: Hi
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts FTP Skip or ignore error and process ... AJAYREDDY All Other Mainframe Topics 3 Wed Sep 27, 2017 8:12 pm
No new posts Issue with NDM process to transmit ES... chetanambi All Other Mainframe Topics 6 Wed May 03, 2017 10:52 am
No new posts Storing huge volume of data, compare ... Pradeep K M All Other Mainframe Topics 3 Mon Jan 16, 2017 5:08 pm
No new posts Viewing executing process in NDM .. q... Debb.Brant IBM Tools 0 Wed Dec 14, 2016 10:55 pm
No new posts How to make REXX process different GDGs? venksiv CLIST & REXX 15 Thu Sep 24, 2015 5:35 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us