Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [db2-10.5]

DB2 is a database management system from IBM. This tag should be used for questions about the 10.5 version of DB2. Please additionally tag your question with the generic "db2" tag.

Released in 2013, DB2 10.5 builds upon the "pillars of DB2": low operational costs, ease of development, and reliability. This release introduced column-organized table functionality to DB2 for Linux, UNIX, and Windows.

DB2 10.5 for Linux, UNIX, and Windows can deliver top performance, and capture business insight more easily through high speed analytics over large data volumes.

DB2 10.5 includes BLU Acceleration, a collection of technology innovations from the IBM Research and Development Labs that speed up reporting and analytics. BLU Acceleration, which eliminates the need for indexes, aggregates, or time consuming database tuning to achieve top performance and storage efficiency, is a fully integrated capability in DB2 10.5 for Linux, UNIX, and Windows.

46 questions
5
votes
1 answer

What is the meaning of `(ORDER BY x RANGE BETWEEN n PRECEDING...)` if x is a date?

In another thread: https://stackoverflow.com/questions/37759659/db2-query-to-find-average-sale-for-each-item-1-year-previous the OP wanted a sliding average for the last 365 days. Using ROWS BETWEEN ... would be fine if it where guaranteed that…
Lennart - Slava Ukraini
  • 23,842
  • 3
  • 34
  • 72
5
votes
1 answer

Windows to DB2 Connection: Connection authorization failure occurred. Reason: Local security service non-retryable error

Error creating SQL Model Connection connection to TSMDB1. (Error: [jcc][t4][2010][11246][3.68.61] Connection authorization failure occurred. Reason: Local security service non-retryable error. ERRORCODE=-4214,…
WernerCD
  • 1,245
  • 3
  • 11
  • 19
3
votes
1 answer

What might be the reason for licence compliance violation?

Much to my surprise we got a licence compliance violation for our DB2 Workgroup Server Edition installation regarding: ~]$ db2licm -g tmp.txt ~]$ cat tmp.txt License Compliance Report DB2 Workgroup Server Edition Violation Materialized…
Lennart - Slava Ukraini
  • 23,842
  • 3
  • 34
  • 72
3
votes
1 answer

non-optimal use of index

I'm somewhat puzzled by the scenario below. The table involved (relevant parts) is defined as: CREATE TABLE Nya. UPSEC_COURSE ( UPSEC_COURSE_ID CHAR(11) NOT NULL, CORE_UPSEC_SUBJECT SMALLINT NOT NULL WITH DEFAULT 0, …
Lennart - Slava Ukraini
  • 23,842
  • 3
  • 34
  • 72
2
votes
1 answer

DB2 - how to call a stored procedure that returns a result set in another user defined table function

I have a db2 stored procedure that takes in some parameters, gets some data from somewhere and then returns a result set through a cursor. Now I want to write a table function in db2, that will call this stored procedure, read from the result set…
Carrington C
  • 21
  • 1
  • 2
2
votes
0 answers

Can we prevent creation of directory NODE0000 during db2 rollforward db end of logs with overflow log path option?

I am using command rollforward db ABCD to end of logs overflow log path ('/db2backup/logs') to apply DB2 archived logs to my staging database. My staging database is in rollforward pending state. Execution of command is fine when instance user have…
hemant gairola
  • 21
  • 1
2
votes
1 answer

How to avoid SQLCODE=-968, SQLSTATE=57011 "The file system is full" error with merge statement

When doing the following merge (tempchoices is a temporary table created with DECLARE GLOBAL TEMPORARY TABLE tempchoices LIKE CHOICES NOT LOGGED IN importtemp ON COMMIT PRESERVE ROWS) all my diskspace gets used and I receive the "The file system is…
Tekcins
  • 21
  • 1
  • 1
  • 3
2
votes
2 answers

DB2 on Windows: Fix encoding in db2cmd and for JDBC

I'm running a DB2 v10.5 FP 7 on a Windows Server 2013 and there is a problem with the encoding setup: The windows is set to use German(Switzerland) as region setting and input language. chcp: Active code page: 850 My database is set to UTF-8, see…
tannerli
  • 141
  • 7
2
votes
1 answer

"symlink" data to new database

I am just trying to figure some ways to do manage archiving of some/most of our Application data within the database and wondering if something like this would be possible: Archive anything with a status of resolved, and a data updated over 3…
AIT
  • 23
  • 2
2
votes
1 answer

Update the value when the row already exists

I have table 'A' in schema 'USER'. There are three columns in this table. below are the names of the columns: id (primary key) name age I want to insert a row in this table, but if the row is already present (with same id) then the name and age…
Govind
  • 123
  • 2
  • 3
  • 13
1
vote
2 answers

DB2 Linux authentication fails

I have DB2 Express-C v10.5 instance configured to authenticate against LDAP. The LDAP sever is going to be shutdown and I should configure the same DB2 instance to use Linux authentication. I copied users from the LDAP  server to a local Linux host…
haba713
  • 111
  • 4
1
vote
1 answer

Using same table in a UNION multiple times

I am given a query that is using the same table with same columns and filters multiple times and the only thing is changing is the Type which is given manually. I am thinking there must be a better way to do that. Query statement is like below: …
Nil R
  • 113
  • 1
  • 4
1
vote
3 answers

Not able to install any DB2 LUW 10.5 fixpacks

I am currently on Fixpack 1 and am trying to install ANY more recent fixpack. All of them refuse to apply themselves with similar errors. The one below is from Fixpack 2 file v10.5fp2_ntx64_server. Each of them up to the most recent says that they…
Gandon Jank
  • 37
  • 7
1
vote
1 answer

DB2 equivalent of Oracle DBMS_LOB.SUBSTR etc

I have to migrate an Oracle stored procedure to DB2 LUW 10.5. It uses DBMS_LOB.SUBSTR() function on a BLOB parameter that receives an array of bytes from the client code. What is its equivalent in DB2? SUBSTRB seems fitting, but I am not sure.
Gandon Jank
  • 37
  • 7
1
vote
2 answers

How to change default db2 database admin username to something else in Linux?

I have a DB2 database version 11.1 on Linux - rhel 7.7 in my test environment. I need help on how to change the default db2 admin username to something else, ie. db2inst1 to dbroot. And the new db2 user - dbroot should have the same privileges which…
Loay
  • 21
  • 2
1
2 3 4