DB2 UDB (universal databases)

Email Alerts

Register now to receive Search400.com-related news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Know-IT-All Chapter Quiz: The Programmer's Guide to iSeries Navigator

    Think you know all there is about simple database features? We challenge you to test your skills by taking our latest quiz. Share the results with us and get a chance to win a copy of "The Programmer's Guide to iSeries Navigator" written by Paul Tou... 

  • DB2 crossword challenge

    Are you a DB2 dynamo? Take our DB2 crossword challenge and find out! 

  • Answers to DB2/400 DB2 UDB Fact or Fiction?

    Answers to DB2/400 DB2 UDB Fact or Fiction? 

  • DB2/400 DB2 UDB Fact or Fiction?

    DB2 expert Kent Milligan provides advice to Search400.com's members on a regular basis. Do you feel you're also a DB2 guru? Test your knowledge against some of Kent's recent Q&As below. Mark each question with either a True or False. Jot down your a... 

  • Guide to IBM redbooks on iSeries stored procedures

    IBM Redbooks cover a wide variety of iSeries topics. This guide to IBM Redbooks focuses on stored procedures for the iSeries that range from Redbooks for novices to iSeries pros. Plus, we've thrown in some example code and how-tos. 

  • Oracle boasts 11g on SPARC is faster than IBM DB2 on Power 595

    At Oracle Open World in San Francisco, the company shared new speed marks for its application server and database as the company's Fusion Middleware took center stage. A $10-millon prize was offered to anyone who can show that a Sun-Oracle configurat... 

  • How to: Sort arrays using RPGIV

    RPGIV allows you to sort arrays by creating records that contain elements that are in turn treated as a separate array. This allows you to sort the elements of the record in different ways depending on your needs. In this example, you can sort by SUM... 

  • Debating DB2 versus Oracle

    Contributor Andrew Borts has a little fun with a mock debate between DB2 and Oracle. Addressing misconceptions about DB2's functionality and integration with OSes outside of i5, Borts concludes that DB2's advantages mostly lie in return on investment... 

  • IBM i news updates for the week of 10/13/2008

    IBM is reportedly developing DB2/400 to power MySQL, and will now pre-install IBM i 6.1 and pre-configure the Virtual I/O Server (VIOS) on JS12 and JS22 blade servers. New storage options have also been announced, with the System Storage 7214 Tape a... 

  • How to: Transfer unlimited data to Excel from AS/400

    Using the data transfer from iSeries utility in Client Access allows you to transfer data from the AS/400 to Excel. By setting up the worksheet type and optional setting for Excel to start a new worksheet you can avoid running out of room on a single... 

  • The enhanced DB2 inside i5/OS V6R1

    Along with i5/OS V6R1 is the DB2 that comes with it, and as there are enhancements in V6R1, so there are for DB2, IBM's relational database management system. 

  • 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. 

  • 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 

  • 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. 

  • 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. 

  • See more News on DB2 UDB (universal databases)
  • Database performance comparisons on IBM i

    Testing performance of RLA in the IBM Java Toolbox against JDBC and native I/O for the AS/400 revealed that RPG on System i is the most efficient language, and DB2 is taken for granted. Joe Pluta built some benchmarks to compare different aspects of ... 

  • Database drivers on the i: MySQL vs. IBM Toolbox

    Which reads data from i faster: MySQL or IBM Toolbox drivers? Joe Pluta put the drivers to the test in both an AS/400 and a Windows environment. The conclusion: MySQL over its own database performs roughly as well as IBM's Java Toolbox over DB2 data,... 

  • DB2 on AS/400: What has it done for me lately?

    AS/400 has the full functionality of DB2 built in, giving it an advantage over other platforms. DB2 supports referential integrity, triggers, journaling and extensive error handling. A brief history of the database is provided. 

  • What is an integrated database?

    The integrated database feature on the AS/400 is often taken for granted. Comparisons of the IBM DB2 against SQL for performance, cost, and support are provided. The results may surprise you. 

  • An automated CL method of moving a query from AS/400 to Excel

    If a daily task of your AS/400 is to print a report from a query a CL program can be written to automate the task and make it easy to open the results in Excel. This CL program copies an existing query to QTEMP and runs the query. Then it converts th... 

  • Checking database cross-reference files

    There is a simple way to check if your cross-reference files are in error, or if your system objects are in error -- without waiting for crash. Type GO LICPGM, and then option 5 and select verify system objects. If everything is OK, you should receiv... 

  • iSeries (AS/400) DB2 UDB: Top 10 expert questions

    Kent Milligan, iSeries/i5 DB2 UDB expert, has been answering Search400.com's member questions for more than five years. iSeries users have asked Kent the same questions again and again. In an effort to save you time, we've compiled the top 10 questio... 

  • Retrieve SQL (RTVSQL) source statement

    Search400.com member Jean-Paul Lamontre discusses the SQL Visual Explain tool, which comes with iSeries Navigator. Jean-Paul finds this tool very handy to improve the performance of SQL statements. In this tip he shares why he feels it would be benef... 

  • Basic DB2 buffering and memory guidelines

    A high-level trip through DB2's memory structures. 

  • Getting started with DB2 application tuning

    Some of the steps necessary to locate and tune DB2 application performance problems. 

  • See more Tips on DB2 UDB (universal databases)
  • database mirroring

    Database mirroring is the maintenance of redundant copies of a database to ensure continuous data availability and minimize or avoid downtime that might otherwise result from data corruption or loss, or when the operation of a network is partially c... 

  • database mirroring

    Database mirroring is the maintenance of redundant copies of a database to ensure continuous data availability and minimize or avoid downtime that might otherwise result from data corruption or loss, or when the operation of a network is partially c... 

  • Oracle boasts 11g on SPARC is faster than IBM DB2 on Power 595

    At Oracle Open World in San Francisco, the company shared new speed marks for its application server and database as the company's Fusion Middleware took center stage. A $10-millon prize was offered to anyone who can show that a Sun-Oracle configurat... 

  • 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 t... 

  • 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. 

  • 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. 

  • 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. 

  • 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. 

  • 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 ... 

  • Access path and an open data path differences

    On AS/400 DB2 an access path describes the order in which the rows are retrieved from a database file. The open data path (ODP) is the path through which all input and output operations are performed on a database file. As data is retrieved from or ... 

  • Database performance comparisons on IBM i

    Testing performance of RLA in the IBM Java Toolbox against JDBC and native I/O for the AS/400 revealed that RPG on System i is the most efficient language, and DB2 is taken for granted. Joe Pluta built some benchmarks to compare different aspects of ... 

  • See more All on DB2 UDB (universal databases)