In the first part of this series on the DISPLAY command, we focused on using DISPLAY to monitor details about you database objects. In today's second installment of this series, we will look into using DISPLAY to monitor your DB2 buffer pools.The DISPLAY BUFFERPOOL command can be issued to display the current status and allocation information for each buffer pool. For example:DSNB401I =DB2Q BUFFERPOOL NAME BP0, BUFFERPOOL ID 0, USE COUNT 202 DSNB402I =DB2Q BUFFER POOL SIZE = 4000 BUFFERS AUTOSIZE = NO ...
Wednesday, 25 September 2013
Wednesday, 18 September 2013
Using the DISPLAY Command, Part 1
Posted on 14:12 by Unknown
Often times some of the simplest commands and features of DB2 can be used to great effect -- if you just remember that they are there and learn how to use them. The DISPLAY Command is one of those features.Although a DB2 performance monitor is probably the best solution for gathering information about your DB2 subsystems and databases, you can gain significant insight into “what is going on out there” using the simple DISPLAY command.In today's blog post, and a series of subsequent posts, we will learn about the DISPLAY command and how it can be...
Wednesday, 11 September 2013
Answering a Question: Dealing with Different Data Types
Posted on 15:16 by Unknown
I get a lot of e-mail. Some of it is junk, but some of it contains questions on all sorts of issues. I cannot answer everything that comes into my in box or I wouldn't have time to earn a living. But every now and then I will answer a question here on the blog.Today's question is:Dear Mr. Mullins, I have a question I hope you can help me with. In DB2 I am attempting to compare two columns, however one column is data type "Integer" and the other is data type "Decimal". Can you give me an idea on how to convert the data types so...
Friday, 6 September 2013
Top Ten Most Pervasive Myths About DB2 for z/OS
Posted on 14:47 by Unknown
Today's blog offers up yet another Top Ten list for DB2 users, perusers, and abusers... This time counting down the most common myths that are perpetrated "out there" regarding DB2 and how it works (or doesn't work)...1.Use Views to Insulate Programs from Change This lie has been told for almost as long as DB2 has been around. I first wrote about this way back in 1991 for Database Programming & Design. Check that article out here if you don't understand why this is a bad idea, in general. 2.Locking...
Sunday, 1 September 2013
Top Ten Common SQL Mistakes (with DB2 for z/OS)
Posted on 13:04 by Unknown
!-- .tab { margin-left: 540px; } There are many different types of development mistakes that can be made when you are coding a complex application system. But probably the most pervasive mistakes being made when developing an application using DB2 for z/OS are SQL mistakes... well, actually, that statement is probably true regardless of the DBMS, but I am going to focus on DB2 for z/OS given that this is a blog that focuses on DB2 and mainframe issues.Assuming an ORDER BY is not necessary for ordered results - if you want your results always to...
Subscribe to:
Posts (Atom)
