Hot answers tagged

3

It's a very open-ended question, as there is no sure-fire method to determine the server version and platform. You'll need to apply some heuristics. In Db2 for LUW (and only LUW) since v 10.1 there's a system view dbmcfg that can return the server version: select value from sysibmadm.dbmcfg where name = 'release' so if it succeeds you'll be sure it's Db2 ...


3

I posted this answer in response to the same question on StackOverflow, so here is a re-post: An important distinction to make is that according to IBM, zIIP is only available for "eligible database workloads", and those "eligible" loads are mostly targeted for large BI/ERP/CRM solutions that run on distributed servers, which are connecting through DDF (...


2

They probably do this because storage allocation on the mainframe is much more complex than for unix or windows platforms. zOS is basically a very modern sophisticated piece of harware and operating system that is emulating a 1960s mainframe. In much the same ways as the latest Intel chips are emulating a 1980s 386 chip. The problem is that the very low ...


1

CTE part returns stores and dates that have not sold this products '001,002,003', the second part returns only those that have not sold any of them. NOTE: COUNT(*) = 3 because you're looking for 3 products. WITH ct AS ( SELECT store_id, dt, product_code FROM DAILY_SALES_RECORDS WHERE product_code IN ('001', '002', '003') GROUP ...


1

The "to-string" in your TRANSLATE is a single "X", so only the first character found in "from-string" (X'00' in your case) will be translated to "X". All other characters found in "from-string" will be replace by the "pad" character. You don't specify one, so a blank is used by default. This is why the X'15' at the end of your inut field is translated to X'...


1

BLOB should be translated to bytea in Postgres and CLOB to text. DECIMAL(15) is probably better done as bigint and char() should not be used at all. I would replace that with varchar(30) I don't know what rowid is in DB2. The with default option is invalid for Postgres. If you want a default value you need to specify it explicitly, e.g.: field_6 ...


1

If the application is hard-coded with the qualifier, then it can only use that qualifier and SCHEMA.table-name is unique. The best approach is rewrite the application to use unqualified table names. If you do end up considering creating additional subsystems, you might consider zD&T. This is z/OS running on Linux on x86 for dev/test environments. ...


1

First of all, the syntax for a named parameter marker is CONCAT(:queryDate, '-12.00.00.000000'), that is, it begins with a colon, not a question mark. Processing of parameter markers is performed on the client side, not on the server, and it's irrelevant if your server happens to be DB2 for z/OS or not. The IBM Data Server Client (the common driver for IBM ...


1

Your OS authorities don't matter to DB2, which has its own authorization mechanism, although it is based on the OS authentication. In other words, you must have a login ID in the OS, which, if you are successfully authenticated, will be used to determine what authorizations you have from the DB2 point of view. You can read more about the model here: http://...


1

The point of zIIP processors is that you can't run z/OS code on them. Your COBOL code won't run on them. However, according to this article DB/2 for z/OS is an eligible workload to run on a zIIP processor. I presume your COBOL code has embedded SQL. Embedded SQL architectures are actually preprocessors that generate code that sends the query off to the ...


Only top voted, non community-wiki answers of a minimum length are eligible