DB2 UDB (universal databases)
New & Notable
Advance your data center career by mastering these 5 IT Skills
Maintaining an IT skill set that is up-to-date is essential, not just to maintain your career, but to advance it as well --otherwise you risk falling behind in this fast-paced, extremely competitive IT job market. Access this 25-page guide for expert insight, career forecasts and tips you need to know to keep your IT skills sharp.
DB2 UDB (universal databases) News
-
August 03, 2006
03
Aug'06
IBM releases DB2 email archiving hardware and software
IBM announced the release of its DB2 CommonStore Email Archiving Solution, an appliance that SMBs with little to no IT staffs can install quickly and easily.
-
June 15, 2006
15
Jun'06
DB2 Viper to boost XML capabilities
Analysts say the big plus for the System i in IBM's DB2 Viper release, is its ability to leverage XML for service-oriented architectures
-
December 12, 2005
12
Dec'05
Unstructured info management on the iSeries
Big Blue unveiled new software for iSeries shops that want to get more out of unstructured information, such as call center notes, e-mails and printed documents.
-
April 12, 2005
12
Apr'05
IBM steps up iSeries, pSeries overlap
IBM announced Tuesday the latest in a series improvements to its iSeries line, which analysts say is evidence of a trend towards an increased overlap with the pSeries.
DB2 UDB (universal databases) Get Started
Bring yourself up to speed with our introductory content
-
Making a file with an automatic key in iSeries with DDS keyword
If you want to create an automatic key using a DDS keyword on AS/400, Kent Milligan explains that any native writes performed against an SQL table created with an identity table will result in DB2 generating identity values. Continue Reading
-
WebSphere Development Studio Client (WDSC)
WebSphere Development Studio Client (WDSC) is a set of application development tools designed for the IBM (International Business Machines) iSeries server. The WDSC basic edition offers user-friendly, easy-to-learn tools to help providers optimize ... Continue Reading
-
AIX (Advanced Interactive eXecutive)
AIX is an open operating system from IBM that is based on a version of UNIX. Continue Reading
Evaluate DB2 UDB (universal databases) Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
-
Choose which column names are returned via ODBC when working with DB2 files
When working with DB2 files with columns that have both short and long names, there is no option choose which column names are returned via ODBC because SQL-based interfaces use the long column name by default. Continue Reading
-
Developing tables in a parent-child relationship in DB2
When developing tables in a parent-child relationship, use a primary key and a foreign key along with a unique ID to make your database easier to maintain over time. Continue Reading
-
When is the YES option for 'reuse deleted files' function the best choice?
IBM did not change the default of the reuse deleted files function to YES for physical files in order to minimize the impact on any existing applications that may have dependencies on deleted records that are not being used. However, there there are... Continue Reading
Manage DB2 UDB (universal databases)
Learn to apply best practices and optimize your operations.
-
How to select disk drives for DBMS
This tip offers suggestions about what to take into account when choosing disks for database management systems. Continue Reading
Problem Solve DB2 UDB (universal databases) Issues
We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.
-
Monitoring members 'stuck' within a physical file on an EDI system
To monitor members stuck within a physical file on AS/400, you can periodically use the display file description (DSPFD) command to create an output file that can be analyzed, or occasionally run queries against the SYSPARTITIONSTAT catalog view in ... Continue Reading
-
SQL server error message -321
To solve the SQL error -321 on IBM i6.1, use the new values statement to overcome the error. If you are using an older release, declare a cursor using dynamic SQL. Continue Reading
-
Creating a host variable of the 'where in' statement in SQL
Create a host variable of the where in statement on the fly with dynamic SQL. Continue Reading