Mainframes, MVS, zOS and Related Languages Support Forums Help & Support Forum for and by Mainframe Users 2013-08-24T18:56:44+00:00 http://www.ibm-mainframes.com/feed.php?f=8 2013-08-24T18:56:44+00:00 2013-08-24T18:56:44+00:00 http://www.ibm-mainframes.com/viewtopic.php?t=180&p=927#p927 <![CDATA[IBM DB2. • Re: What is TRIGGER in DB2?]]>
Thanks Adyanath - but your pdf directs to an Oracle document?

Statistics: Posted by Prakash Jha — Sat Aug 24, 2013 6:56 pm


]]>
2013-08-24T06:57:07+00:00 2013-08-24T06:57:07+00:00 http://www.ibm-mainframes.com/viewtopic.php?t=359&p=916#p916 <![CDATA[IBM DB2. • Re: DSNDB06 and DSNDB07?]]>
DSNDB07 - This is the area where sorting takes place in DB2. When you're using ORDER BY and GROUP BY in your SQL queries, this is part of DB2 which will come to play.

As an end-user or application developer, you'll probably never be bothered about how are these 'objects' of DB2 are configured, however I find this article insetting and possibly you might also like it: Click - search for DSNDB06.

Statistics: Posted by Anuj Dhawan — Sat Aug 24, 2013 6:57 am


]]>
2013-08-23T12:30:37+00:00 2013-08-23T12:30:37+00:00 http://www.ibm-mainframes.com/viewtopic.php?t=359&p=914#p914 <![CDATA[IBM DB2. • DSNDB06 and DSNDB07?]]>
Can anyone tell me what is DSNDB06 and DSNDB07?

what I read is that - DSNDB06 is DB2 catalog database and DSNDB07 is a work file database but contains no permanent data, and can be deleted and redefined with the new qualifier. But is this only what they are for? Or can there be more use of them?

Statistics: Posted by Biden — Fri Aug 23, 2013 12:30 pm


]]>
2013-08-23T08:40:48+00:00 2013-08-23T08:40:48+00:00 http://www.ibm-mainframes.com/viewtopic.php?t=180&p=910#p910 <![CDATA[IBM DB2. • Re: What is TRIGGER in DB2?]]>
Sometimes to keep a track of the changes in a table or to perform an automatical action or to perform an action depending on another action ( Dependency ) DB2 Developer use triggers.

Thanks,
Adyanath Ghosh

Statistics: Posted by Adyanath Ghosh — Fri Aug 23, 2013 8:40 am


]]>
2013-08-20T12:57:05+00:00 2013-08-20T12:57:05+00:00 http://www.ibm-mainframes.com/viewtopic.php?t=309&p=898#p898 <![CDATA[IBM DB2. • Re: What is ROW LOCK & TABLE LOCK and how to implement them?]]> Understanding locking in DB2 Universal Database.

Hope this helps.

Statistics: Posted by Anuj Dhawan — Tue Aug 20, 2013 12:57 pm


]]>
2013-08-10T09:24:36+00:00 2013-08-10T09:24:36+00:00 http://www.ibm-mainframes.com/viewtopic.php?t=309&p=794#p794 <![CDATA[IBM DB2. • Re: What is ROW LOCK & TABLE LOCK and how to implement them?]]> Statistics: Posted by m4mainframe — Sat Aug 10, 2013 9:24 am


]]>
2013-07-31T13:04:24+00:00 2013-07-31T13:04:24+00:00 http://www.ibm-mainframes.com/viewtopic.php?t=310&p=667#p667 <![CDATA[IBM DB2. • Re: Difference between IDMS and DB2?]]>
IDMS (Integrated Database Management System) is primarily a network database management system for mainframes and owned by CA, as Robert has also said. On the other hand, DB2 is a "relational" in its nature. So IDMS is referred as NDBMS (Network Data Base Management Systems) also while DB2 is referred as RDBMS (Relational Data Base Management Systems). Having said that, if we go by the very definitions of these two systems - RDBMS is a DBMS in which data is perceived to be stored in the form of tables and so the relationship among the data is also stored in the form of tables and it follows Codd's rule. NDBMS, on the other hand, is a set of records which is having owner and member relationship within the set.

There had been claims that DB2 was (compared to IDMS) very (and still is) I/O intensive and is nothing more than a means to sell IBM DASD, however, I, for one, cannot vouch for that.

Hope this helps.

Statistics: Posted by Anuj Dhawan — Wed Jul 31, 2013 1:04 pm


]]>
2013-07-29T09:46:50+00:00 2013-07-29T09:46:50+00:00 http://www.ibm-mainframes.com/viewtopic.php?t=310&p=655#p655 <![CDATA[IBM DB2. • Re: Difference between IDMS and DB2?]]> Statistics: Posted by Robert Sample — Mon Jul 29, 2013 9:46 am


]]>
2013-07-29T05:35:35+00:00 2013-07-29T05:35:35+00:00 http://www.ibm-mainframes.com/viewtopic.php?t=310&p=652#p652 <![CDATA[IBM DB2. • Difference between IDMS and DB2?]]>
What is the difference between IDMS and DB2? Are they just same - please tell me? I searched on it but got more confused.

Statistics: Posted by Mukul Roy — Mon Jul 29, 2013 5:35 am


]]>
2013-07-29T05:31:45+00:00 2013-07-29T05:31:45+00:00 http://www.ibm-mainframes.com/viewtopic.php?t=309&p=651#p651 <![CDATA[IBM DB2. • What is ROW LOCK & TABLE LOCK and how to implement them?]]>
What is ROW LOCK & TABLE LOCK and how to implement them? Or if you can direct me, how can I perform ROW Lock and table Lock in DB2?

Statistics: Posted by Vibha — Mon Jul 29, 2013 5:31 am


]]>
2013-07-26T12:53:02+00:00 2013-07-26T12:53:02+00:00 http://www.ibm-mainframes.com/viewtopic.php?t=256&p=622#p622 <![CDATA[IBM DB2. • Re: We made a Century!!]]> Making Century is a history now -- We made Much More than a Double Century!

script
Most users ever online was 250 on 26 Jul 2013
script 01:01


What are you waiting for -- come get along with this busy community to clear, debate and discuss your doubts on IBM Mainframes, MVS, zOS and related Languages.

Statistics: Posted by Anuj Dhawan — Fri Jul 26, 2013 12:53 pm


]]>
2013-07-26T04:48:11+00:00 2013-07-26T04:48:11+00:00 http://www.ibm-mainframes.com/viewtopic.php?t=295&p=619#p619 <![CDATA[IBM DB2. • "Report This Post" is activated.]]>
The "Report This Post Button" can be found as the first button with exclamation sign ("!"), at bottom right of any post. The pictorial representation is shown below:

Statistics: Posted by Anuj Dhawan — Fri Jul 26, 2013 4:48 am


]]>
2013-07-19T19:11:01+00:00 2013-07-19T19:11:01+00:00 http://www.ibm-mainframes.com/viewtopic.php?t=256&p=532#p532 <![CDATA[IBM DB2. • Re: We made a Century!!]]>
Today it is 165!!!

Statistics: Posted by Anuj Dhawan — Fri Jul 19, 2013 7:11 pm


]]>
2013-07-18T05:35:38+00:00 2013-07-18T05:35:38+00:00 http://www.ibm-mainframes.com/viewtopic.php?t=256&p=507#p507 <![CDATA[IBM DB2. • We made a Century!!]]>

We got 121 users online Yesterday, on 17 Jul 2013 at 22:54. You can check that at the bottom of Board Index. This will be shown like this: "Most users ever online was 121 on 17 Jul 2013 22:54".

That's a great achievement.

Thanks for Liking and showing the trust in to the Labor we're putting in, much appreciate that,

Thanks,

Statistics: Posted by Anuj Dhawan — Thu Jul 18, 2013 5:35 am


]]>
2013-07-02T18:39:49+00:00 2013-07-02T18:39:49+00:00 http://www.ibm-mainframes.com/viewtopic.php?t=179&p=292#p292 <![CDATA[IBM DB2. • Re: What is the difference between QMF & Spufi?]]> Statistics: Posted by Robert Sample — Tue Jul 02, 2013 6:39 pm


]]>
2013-07-01T17:04:22+00:00 2013-07-01T17:04:22+00:00 http://www.ibm-mainframes.com/viewtopic.php?t=180&p=287#p287 <![CDATA[IBM DB2. • Re: What is TRIGGER in DB2?]]> Statistics: Posted by Anuj Dhawan — Mon Jul 01, 2013 5:04 pm


]]>
2013-07-01T10:54:14+00:00 2013-07-01T10:54:14+00:00 http://www.ibm-mainframes.com/viewtopic.php?t=180&p=274#p274 <![CDATA[IBM DB2. • What is TRIGGER in DB2?]]>
I'm not sure what is a trigger in DB2 and where it is used?

Statistics: Posted by Prakash Jha — Mon Jul 01, 2013 10:54 am


]]>
2013-07-01T10:53:08+00:00 2013-07-01T10:53:08+00:00 http://www.ibm-mainframes.com/viewtopic.php?t=179&p=273#p273 <![CDATA[IBM DB2. • What is the difference between QMF & Spufi?]]> Statistics: Posted by Prakash Jha — Mon Jul 01, 2013 10:53 am


]]>
2013-07-01T05:18:49+00:00 2013-07-01T05:18:49+00:00 http://www.ibm-mainframes.com/viewtopic.php?t=171&p=272#p272 <![CDATA[IBM DB2. • Re: What is difference between Table and View in DB2?]]> Statistics: Posted by Anuj Dhawan — Mon Jul 01, 2013 5:18 am


]]>
2013-06-23T15:39:08+00:00 2013-06-23T15:39:08+00:00 http://www.ibm-mainframes.com/viewtopic.php?t=171&p=255#p255 <![CDATA[IBM DB2. • What is difference between Table and View in DB2?]]> Statistics: Posted by utkarsh — Sun Jun 23, 2013 3:39 pm


]]>