DB2 Universal Database

Toad for DB2

2007-02-15T12:37:00.000+05:30

Toad™ for DB2 is a database development and administration solution that maximizes DB2 code quality while improving developer productivity.

Download for free: http://toadsoft.com/toaddb2/lic_agree.html

Try this if you have system installed with db2 system

Key Features
Master Detail Browser : Allows browsing and editing of data from related tables through one user interface
ER Diagrams: Allows automatic creation of ER diagrams for database tables
Report Designer: For creating professional reports
Debugger : Permits line-by-line and statement-by-statement debugging for SQL, Stored Procedures, and Triggers. Users can step through code one line at a time as it executes on the server, set conditional breakpoints, watch and modify variables, and view the execution stack.

Tables and Their Cousins

2007-01-31T17:40:00.000+05:30

From Craigmullins.

In an today's SQL DBMSes the primary access point for data is the "table." A table consists of multiple rows, each with a fixed and unchanging number of defined columns. But there are several table alternatives that behave just like tables.
For example, DB2 allows the following:
ALIAS - an alternative name that can be used in SQL statements to refer to a table or a view in the same or a remoteDB2 subsystem.
SYNONYM - an alternative name that can be used in SQL statements to refer to a table or a view in the same DB2 subsystem. Synonyms are accessible only by the synonym owner.
VIEW - an alternative representation of data from one ormore tables or views.

What is fenced user-defined function and non-fenced user-defined functions?

2007-01-24T18:28:00.000+05:30

What is fenced user-defined function and non-fenced user-defined functions?

When a fenced user defined function is invoked, DB2 starts a sub-process, which loads the shared module/dll holding the user-defined function. The main DB2 process then communicates with the sub-process via IPC to pump data through the user defined function.

In the case of an unfenced user defined function, the main DB2 process loads the shared module/dll holding the user-defined function directly and calls the function directly.

An unfenced function is vastly faster than the fenced function. However, the trade off is that if you have any errors in the UDF, then you will crash the main DB2 engine and the system will be down, and will require a recovery when restarted. So, if you are POSITIVE you have no errors in your UDF, then make it unfenced.

Fenced Functions are stored in sqllib/function and unfenced functions are stored in sqllib/unfenced

Drop table if it exists

2007-01-16T15:48:00.000+05:30

Begin atomic
if(exists(select 1 from syscat.tables where tabschema = 'MYSCHEMA' and tabname = 'MYTABLE'))
then drop table MYSCHEMA.MYTABLE;
end if;
End

DB2 9 Data Compression

2007-01-16T14:58:00.000+05:30

For large warehouses or databases with huge volumes of data, the cost of the storage subsystem can easily exceed the combined cost of the hardware server and the data server software. Therefore, even a small reduction in the storage subsystem can result in substantial cost savings for the entire database solution.

The new data row compression technology in DB2 9 can save up to 80% savings on disc space and I/O improvements of up to 40%.
If the volume of the data you need to manage is exploding, you may want to take a closer look at DB2 9.

Entry Statement

2006-12-18T09:03:00.001+05:30

The ENTRY statement establishes an alternate entry point into a COBOL called subprogram.
When a CALL statement naming the alternate entry point is executed in a calling program, control is transferred to the next executable statement following the ENTRY statement.

Entry Statement

2006-12-18T09:03:00.000+05:30

Setting Return Codes in Cobol

2006-12-18T09:02:00.001+05:30

There is a “special register” called RETURN-CODE in every COBOLprogram. It is defined by the system as PIC S9(4) COMP VALUE ZERO.
At the start of a program, it is initialized to 0 and is updated aftereach CALL statement.In a COBOL program that needs to set a return code:
MOVE return-code-value TO RETURN-CODE. GOBACK.In a COBOL program that needs to check a return code:
CALL ‘SUBPGM’ USING PARM1. IF RETURN-CODE = return-code-value

Setting Return Codes in Cobol

2006-12-18T09:02:00.000+05:30

The Aging Mainframer

2006-12-18T09:01:00.001+05:30

The Aging Mainframer -from craigmullin’s

The mainframe experts are getting older and slowly retiring. And who willreplace them? Most young IT professionals do not choose to work onmainframe systems, instead choosing to concentrate on the latest technologybandwagons — things like Windows and Linux, open source and so on.

Put oneof these newbies in front of a terminal and introduce them to the joys ofJCL, ISPF and COBOL, then watch them scream out the door yelling “I want myJava, .NET!”I also screamed like this before…what about u ? will u replace …Today’s mainframe environment is quite different from the mainframe ofyesteryear. That hulking, water-cooled beast you may remember has beenreplaced with chip-based, CMOS, air-cooled systems.

Today’s mainframes areeasier to hook together using Parallel Sysplex technology. And all of the“modern” technology used on Windows and Linux platforms works on themainframe, too. Yes, that means XML, TCP/IP, Java and so on all work on themainframe, too.We would like to work on these advance stuff’s… But Only few are gettingchance..Reality, lot’s of opportunity are there for mainframe experts…

The Aging Mainframer

2006-12-18T09:01:00.000+05:30

The Aging Mainframer -from craigmullin’s

REAL facts about Mainframe - 16 TH IS REALY TRUE

2006-12-18T08:59:00.001+05:30

REAL facts about Mainframe - 16 TH IS REALY TRUE

1. The mainframes hold approximately ” 70 % ” of the entire data stored in this planet

2. The latest ones can support over 25,000 users

3. They can support devices spread over 26 miles using fibre optics

4. The size of the “basic” OS is about 14 GB

5. This OS comes in about 57 magnetic tapes, But latest with 4 tapes

6. It takes ATLEAST a month to install and customize a basic mainframe OS configuration

7. It takes around 3 full days for a mainframe to get up and running

8. Basic configuration for development environment costs 8 crores (hardware + Software)

9. A full team of qualified system operators are always required to be on stand by to ensure successful operation10. Earlier mainframes were provided with cooling pipes through which cold water was passed to cool the system - TCS have one in Chennai facility

11. Recent mainframes have variable speed fans in the cabinet to keep it cool

12. Have u ever heard of a mainframe system being hacked??? Mainframes are one of the most secure data installations ever

13. You cannot buy the mainframe OS, but u’ll have to pay a license to use it. The cost?? cool ….. 1.5 crores a year.

14. Finally, mainframes today r the most preferred data servers for even the most hi-fi of the organizations!

15. So far no virus has been attacked Mainframes

16. Most of the peoples working on Mainframe had never seen the mainframe

REAL facts about Mainframe - 16 TH IS REALY TRUE

2006-12-18T08:59:00.000+05:30