Subscribe to IBM iSource, your electronic source for customized IBM. LAS VEGAS - Looking to keep its installed base of database users happy, IBM continues to enhance its DB2 relational database product family with boosts in. Page Sizes in DB2 UDB DB2 UDB supports four different page sizes: 4 KB, 8 KB, 16 KB, and 32 KB. DB2 Universal Database service is extended to January 31, 2001. Initially DB2 was developed for specific platform of IBM. So The idea of the app is to look up the age of the database and drop it, if it's older than 6 months (for example). The Version 8.2.2 update of the IBM DB2 Universal Database product (DB2 UDB) includes a new capability that allows database administrators (DBAs) to use a single page size for their entire database. The name DB2, or IBM Database 2, was first given to the Database Management System or DBMS in 1983 when IBM released DB2 on its MVS mainframe platform. However for one reason or another (ex: developer not cleaning after himself or tests stopping forcefully before they can do the clean up) some databases never get dropped and they start to get accumulated till the hard disk is filled out eventually. Step 1: Create a sample database table in IBM Db2. It's never meant to keep the data for long time. Tools To Connect To Db2 DatabaseHere is our list of the seven best IBM Db2. I have a server with DB2 DBMS where many people and automated scripts are using it to create some databases for temporary tasks and tests. Since more than one person asked why do I need to do this and for what reasons, here is the background story. Is there another way of doing this through a DB2 command instead, so I wouldn't need to connect to the database? Require me to connect to the database first, like: db2 connect to dbname user userName using password How can I obtain the creation date or time of an IBM's DB2 database without connecting to the specified database first? Solutions like: select min(create_time) from syscat.tables
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |