Hi all, I tried to view the transaction log using “dbcc traceon(3604);dbcc log;dbcc traceoff(3604)“, but the output was not proper or more to say not understandable… Is there a way to view the transaction log in a better understandable way. Continue reading How to view transaction log
I have got 4 MS Access Database Files, which have got 3 Tables each, means Total 12 Tables which gets updated with new data every evening, by an external application. Means new data gets appended to all these 12 Tables. Continue reading Access to SQL Server – How to Auto Update Multiple Tables Daily
Hi Informational tokens are “DB2 v18.104.22.168”, “s130316”, “IP23426”, and Fix Pack “8”. Product is installed at “/opt/IBM/db2e/V9.7”. AIX Have automatic storage tablespace which is have 4 G free space, Tablespace ID = 03 Name = USERSPACE3 Type = Database managed Continue reading How to enable reclaimable_space_enabled for automatic storage tablespace
Hi everyone. I’m starting to use Broker Service for some asynchronous operations. I have all operation (logical) working. The messaging, the conversation, the automatical processin, etc. What I need now, it’s that on the Processing Queue Procedure, I need that Continue reading Insert on another DataBase using Broker Service
I have master slave setup of MySQL with GTID configured. I took back data backup of master and importing it to individual Test server. It is failing to import as Quote: ERROR 1839 (HY000) at line 24: @@GLOBAL.GTID_PURGED can only Continue reading import mysql dump without GTID
Hello all, I have a view VIEW_sale to populate the following data: Invoive# | AmountSale | Invoive_date ————————————————— 1 | 12333.78 | 2015-03-01 00:00:00 2 | 656546.9 | 2015-01-25 00:00:00 3 | 435353 | 2015-03-02 00:00:00 4 | 788.43 | Continue reading Stored procedure to calculate monthly sales by year and quarter to date!
Can anyone help resolve an “idle Instance” of a Oracle XE database upon entry of ‘sqlplus / as sysdba’? Oracle are perplexed. sysdba error.PNG Attached Images sysdba error.PNG (13.4 KB)
Hi, We want to enable parallelism in DB2 10.5. First I have enabled intra_Parallel to yes. And then dft_degree to ANY. I am confuse about parameter MAX_QUERY DEGREE, currently its set to 1. Should I change to more then 1?
Hi, I have a sample stored procedure sp_get_employee_leave with: SELECT employee_leave_day FROM employees WHERE employee_id = param_employee_id; I want to know how can I call sp_get_employee_leave to get the data for all employees using a loop.. something like: For (i=0; Continue reading Loop a Stored Procedure
DB2 10.1 fp2 on linux x64 simple database without dpf having a simple table only db in the instance/machine (0)[db2inst1@plx00003 retrieve]$ db2 describe table legal.gm_ssin Data type Column Column name schema Data type name Length Scale Nulls ——————————- ——— ——————- Continue reading tempspace usage