• IBM DB2 Rows-Records Limits

    IBM DB2 allows up to a maximum of 4.2 Billon rows or records in a table. (In AS/400, iSeries). MS SQL, Sybase SQL, Oracle, MySQL all allow way more. We know that with clusters IBM can handle more, but this doesn’t solve the problem in many cases (Requires Embedded SQL)… DB2/400 was supposed to...

    Florenjm180 pointsBadges:
  • How DB2 converts the FLOAT value to IEEE floating-point format?

    I had created a SQL table as below: CREATE TABLE MYLIB/Mytable (FLD1 FLOAT (9) NOT NULL WITH DEFAULT) When I ran DSPFFD, I had seen that FLOAT(9) gets converted to 3F 2. So, I want to understand how does it happen? Which algorithm is being used?

    manojibmi5 pointsBadges:
  • List libraries and size used by DB2

    How do I list all the libraries used by DB2 in an AS/400 environment?

    gmorote15 pointsBadges:
  • AS/400 DB2 Sav file

    Can an AS/400 DB2 Sav file be restored or migrated to MS SQL Server or Oracle? If not, can non IBM program or script be used to parse data from a SAV file?

    jknight275 pointsBadges:
  • DFU with VARCHAR fields?

    Can I use DFU to maintain VARCHAR fields in a table? If not, is there another easy utility that I can give users to add text to such a file?

    markhod5 pointsBadges:
  • Interface DB2 to Oracle

    Dear all, I  have an 02 database (Oracle database 11 and DB2). I'm using inquiry command SQL in DB2 select about 2 million records very fast but interface to ORACLE by Database gateway transaction process very slow. Please give me reccommend or doccument. Thanks for help

    Hvphong031160 pointsBadges:
  • Problem with character alignment on output or retrieval of variables

    We have an issue we have never seen before but I'm sure happens all the time. We have a DDS screen where the character's are shown as follows:- RETAIL LOGISTICS                     : £99.00 RETAIL FREIGHT                         :£120.00...

    Sxlad200145 pointsBadges:
  • How to find the list of queries (WRKQRY) using a PF

    I want to list down all the Queries build using WRKQRY which are using a particular Physical File.

    asakla245 pointsBadges:
  • DB2: Decrease column length

    Can I decrease the column length in DB2? In one of my columns, it's currently defined as VARCHAR(80). I want to move it to VARCHAR(60). How can I do that?

    ITKE440,635 pointsBadges:
  • Identifying DB2 port number in Java

    My boss asked me to make a DB2 connection using a port number in Java. But I'm not sure what the port number is. Is there any DB2 command to identify it? Thanks.

    ITKE440,635 pointsBadges:
  • From DB2 in mainframe to distributed server

    How can I switch from a DB2 in mainframe to a distributed server?

    dbaadmin15 pointsBadges:
  • Connecting SPSS to AS/400 DB2

    Hi I need to connect SPSS to AS/400 DB2 in order to run queries and get data. I try to connect using iSeries Access ODBC Driver I receive the following error: "Database connection failed. The driver may not be configured properly." I tried to connect to AS/400 from ACCESS and from iSeries Navigator...

    felixb95 pointsBadges:
  • Mainframe Decomission

    Hi All, I am working on Mainframe decommission project. This application also having DB2 as database. I want to know the DB2 removal process. Like first I need to remove tables, table spaces than storage group. I want help on the same. How can I remove all db2 components any command or process....

    amittandon7865 pointsBadges:
  • DB2 on IBM iSeries AS/400

    How to upgrade the version of DB2 in iSeries AS/400?

    kumarbabu5 pointsBadges:
  • DB2 master address space architecture

    Why is the DB2 MSTR still with 31-bit mode? Why can't it exploit the 64-bit? Thanking you in advance.

    duamlee5 pointsBadges:
  • SQL in DB2 for AS/400

    What I have an error when I try to execute the following SQL statement: UPDATE kfilasm/SCPF exception JOIN KFILasm/LDPF ON SCAB = JUBBN and SCAN = JUBNO and SCAS = JUSFX set SCRBA = SCRBA - JUHAMT, SCRBB = SCRBB - JUHAMT WHERE SCAB||SCAN||SCAS IN (SELECT JUBBN||JUBNO||JUSFX FROM QTEMP/JUPF2)

    Messam280 pointsBadges:
  • Load Excel with Japanese characters to iSeries DB2 file

    How do I load an Excel spreadsheet containing Japanese characters to an IBM iSeries DB2 file?

    tonycurtis135 pointsBadges:
  • Error connecting to DB2 on iSeries

    Hello All, I'm getting below error while connecting db2 database on Linux which is cataloged to db2 on iSeries. Kindly help me out on this. db2 -r -u -p **** CLI ERROR ***** SQLSTATE: 58017 NATIVE ERROR CODE: -30073 Distributed Data Management (DDM) parameter value X'119C' not supported. Thanks in...

    umashankar2a120 pointsBadges:
  • DB2 on iSeries V7R1

    Hello all, Can any one help on communicating db2 database on iSeries (V7R1) with DB2 v9.7 client on Red Hat linux ( RHEL6) ..? Thanks in advance. Regards, shankar

    umashankar2a120 pointsBadges:
  • Data schema for migrated data from Jbase to DB2

    How should the data schema looks like after converted it from jBASE to DB2?

    RobaNaji5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.