Hi DB2 experts, I have upgraded several LPARS from version 4 to version 5. DBA upgraded DB2 V9 to V10 before. Client uses RACF external modul for Omegamon installation and RACF authorization for DB2 as well. Because I never installed Continue reading z/OS Omegamon DB2 V 5.2 installation after DB2V10 upgrade. (DB2 PE ISPF OLM issue)
hi friends, i am starting to create my first web application in my career. i am using mysql server. i am going to make table which contain users information (like id, firstname, lastname, email, password, phone number). which is batter Continue reading db manage for improve speed.
Hello everyone I am trying to implement a project in my localhost using Xampp. the problem is that I have MySQL server installed on my PC and the mysql server of xampp does not start because both myslq servers use Continue reading MySQL conflict with xampp
Hi. I perform online backup with “include logs” every 3 days, have logarchmeth1 = disk:/nfs-server/archive-dir and also rsync my instance directory to the same nfs server every 4 hours. Most recent file in archive-dir is at 14:26 (7 hours ago), Continue reading How to rollforward to the very very most recent transaction?
Hello, Please excuse my ignorance as I wasn’t able to get any info from our database people. In short, we have information stored on ORACLE. We will receive a text file to start the process, once that is received a Continue reading Oracle Create a Flag/Dependency
Am I completely missing something here. The first query below works fine for me. But when I add another SELECT around it, I get the error. Is this not possible with DB2? Help!! Thanks!! SELECT FLOAT(SUM(FIALLO-FIORDS))/FLOAT(SUM(FIALLO)) AS mfr, SUM(0) AS Continue reading SQL0104 – Token <END-OF-STATEMENT> was not valid on this select within a select
DB2 9.7.9a ESE running on RH5.3 I am running the same sql statement again and again using db2batch. The strange thing is I get wildly different response times during the FETCH. Anyone have any clue what influences the FETCH phase? Continue reading db2batch – wildly different fetch times during
Hello, Does DB2 support Table Paritioning Interval? For example, in Oracle it has a feature of table partitioning interval. Please find example as below here : – create table pos_data ( start_date DATE, store_id NUMBER, inventory_id NUMBER(6), qty_sold NUMBER(3) ) Continue reading DB2 Table Partitoning
I’ve always user over with partitioning however recently I am looking at some other code and they have calculating percentages using over. I’m at a lost on why you would do this. Example would be CAST(TABLE1.UNIT AS DECIMAL (6,2)) / Continue reading Using OVER Clause
Hi. We have an MQT for a query joining a 100-rows table and a 10Million-rows table. 3rd-party software often issues update statements for the the 100-rows table, but it actually doesn’t change data. However, a single row update causes partial Continue reading Prevent automatic MQT refresh, if column val didn't actually change