hi guys i am a newbee here
plz!! help me!! my exams is on 12 dec

Q1) how cursors,triggers,functions are maintained in db2 product?

Q2) DB2 architecture defining logical n physical data structure?

Q3) on what model db2 is based?

U can also refer a site where i can get the info!!
plz!! plz!! help!!

thnx!!

as always, too late...
it is not possible to explain in some days the complete DB2 terminology and architecture. You will have to study day and night.
Cursor : is part of sql instructions : declare cursor/open cursor...
to fetch data from a database
triggers are db2 objects that are fired whenever the depending table is hit in a specified condition : update/delete/insert..
functions : are DB2 or programming objects that can be defined and called in a user program : eg substr(col,1,1) where substr is a build in function
the architecture and model are basically explained in the administration guides of DB2 documentation. all doc is available online en public...

Read this paper about logical and physical data structures.
In two words:
Logical: about entities, its data elements and relations between entities.
Physical: how things are implemented in the database, entities become tables, data elements fields, relations become FK's and a lot of performance related decisions (indexes, tablespaces, ...) and ease-of use (views, UDF's, SP's). Relational calculus (?)

The ideal answer to most exam questions is very likely to be something that the instructor said in class. Check to see if you took notes, or go to the instructor's office and shoot the breeze with him/her and casually bring up the topics that you need info on.

thx!! guys 4 ur help!!