Search results for query: *

Hi Team, I am using AIX version 7.1 While sending mail from it, it is giving below message asking for 530 Authentication Required: abc@gmail.com... Connecting to xyz.pqr.com. via relay... 220 xyz.pqr.COM ESMTP Service (IBM Domino Release 10.0.1FP1) ready at Wed, 21 Aug 2019 12:24:45 +0530 >>>...

Hi All, I have done table partitioning on 1 table say 'A' in db2 with range as event_date based on date column on yearly basis. Now, I need to partition one more table say 'B' but here in 'B', I dont have any date column. Infact,table 'B' is dependent on table 'A'. Table 'B' is having a column...

Is it possible to transfer the data from a non-partitioned table to a partitioned table using the ADMIN_MOVE_TABLE procedure in db2 10.5 version? As the records in the non-partitioned table is almost 500 million and the performance is degrading day by day on that table. Runstats and Reorg are...

My db2 online backup job was scheduled at 06:00 AM on AIX server. The backup used to start by 06:00 AM but from last 2 days, the backup of db2 databases are starting almost 1-2 hours after the scheduled time which is 06:00 AM I have checked the cron logs and it does not state any error. Please...

I have created an event monitor for locking in db2 as below: CREATE EVENT MONITOR LOCKEVMON FOR LOCKING WRITE TO TABLE; Below tables were created: LOCK_LOCKEVMON LOCK_PARTICIPANTS_LOCKEVMON LOCK_PARTICIPANT_ACTIVITIES_LOCKEVMON LOCK_ACTIVITY_VALUES_LOCKEVMON CONTROL_LOCKEVMON Please...

Thanks alot for the idea.

Thanks for the response.. I was reading blogs on cursors last week and it was mentioned to use scrollable cursors but had no idea how do i implement it for pagination...

I have been searching high and low for the query statement to return a certain row in a result set. I have 10000 records in my result set. I want to retrieve only 50 of them at a time for my pagination. Once I am done, I want to retrieve the next 50 and so forward. Is there a simple and direct...