iSeries database management

Email Alerts

Register now to receive 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
  • 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 compromised.

  • 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 configuration doesn't run at least twice as fast as a comparable setup from IBM.

  • 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 the QSYS2 schema.

  • 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 many customers who use and benefit from the reuse of deleted records.

  • 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 inserted into the file, the ODP will use an access path to navigate to a row within in the file.

  • 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 performance to one another and he provides the results of his testing. Although MySQL is popular and provides an option for prepackaged applications with less stringent database requirements, it won't likely replace DB2 anytime soon.

  • VIEW MORE ON : DB2 UDB (universal databases)