Unlogged Deletes in DB2/390 (or zOS)

peter

Hi All,
a quick question.

I haven't used DB2 on mainframe since 1995 so my memory is fading a
bit. But I seem to recall DB2/MVS having the ability to perform
unlogged deletes.

Situation is I have an oracle partition with 500M rows in it and I need
to update 60M rows and I expect the logging of updates will be too
much...I had proposed that the rows be deleted using unlogged deletes
and then the new images loaded. But I am told oracle does not support
unlogged deletes. So I was just wondering, is my memory of DB2 accurate
in allowing unlogged deletes, or am I just dreaming of the good old
days before everyone bought Oracle all the time...;-)

(Sybase IQ is the only database I know that lets me to unlogged
updates. (Though perhaps DB2 does that now???) )

Thanks

Peter

Nov 12 '05 #1

Subscribe Reply

1930

Walter Schneider

Hello,

as far as I'm aware, DB2 for MVS (now called z/OS) never allowed unlogged
SQL updates/deletes, and the recent versions still allow it for temporary
tables only. What you can do to efficiently delete millions of rows without
filling up your logs, is running the REORG utility with the DISCARD and LOG
NO options in effect. If the filter capabilities of DISCARD do not suit your
needs to identify the rows to be deleted (e.g. because you have to do
subselects or joins to other tables), you may also use the DSNTIAUL sample
unload program to extract the rows NOT to be deleted and then load them back
with LOAD REPLACE LOG NO.

Cheers - Walter.
<pe***@peternol an.com> schrieb im Newsbeitrag
news:11******** **************@ z14g2000cwz.goo glegroups.com.. .

Hi All,
a quick question.

I haven't used DB2 on mainframe since 1995 so my memory is fading a
bit. But I seem to recall DB2/MVS having the ability to perform
unlogged deletes.

Situation is I have an oracle partition with 500M rows in it and I need
to update 60M rows and I expect the logging of updates will be too
much...I had proposed that the rows be deleted using unlogged deletes
and then the new images loaded. But I am told oracle does not support
unlogged deletes. So I was just wondering, is my memory of DB2 accurate
in allowing unlogged deletes, or am I just dreaming of the good old
days before everyone bought Oracle all the time...;-)

(Sybase IQ is the only database I know that lets me to unlogged
updates. (Though perhaps DB2 does that now???) )

Thanks

Peter

Nov 12 '05 #2

Similar topics

4272

db2 v7 zos archive logging

by: Carmine | last post by:

I need to import a huge .ixf file from a pc to db2 v7 zos. Is there a way to stop archive logging while the data is being imported? If not, is it safe to delete archive logs that haven't expired? Thanks.

DB2 Database

2118

Error running db2 utilities on ZOS

by: Prem K Mehrotra | last post by:

I am using db2 version 6 on zos. I am trying to runutility using utilities menu option in spufi. After specifying information on the screen: DB2 UTILITIES "DOWN " is not acti ==> elect from the following: 1 FUNCTION ===> EDITJCL (SUBMIT job, EDITJCL, DISPLAY, TERMINATE 2 JOB ID ===> PMEHROT (A...

DB2 Database

7292

copy a db2/zos table with a blob column

by: Carmine | last post by:

I have to add a date column to a db2/zos table with a blob column. Can I rename the blob table to old, create a new table with the date column, then insert/select the data from the old table? Do I have to select data from the main table and the aux table or is the aux table done automatically? What's the best way to handle this?

DB2 Database

1604

ROW_NUMBER on ZOS/OS390

by: Deepak | last post by:

Hi, Recently while using db2 client 8.1 i faced the problem to use ROW_NUMBER functionality on OS390 platform. Is this function still not available on ZOS ??

DB2 Database

405

Unlogged Deletes in DB2/390 (or zOS)

by: peter | last post by:

DB2 Database

1077

check constraint performance on zos/v7

by: gnuoytr | last post by:

this is from the UDB on-line docs: CREATE TABLE EMPLOYEE (ID SMALLINT NOT NULL , NAME VARCHAR (9), DEPT SMALLINT CHECK (DEPT BETWEEN 10 AND 100), JOB CHAR (5) CHECK (JOB IN ('Sales','Mgr','Clerk')), HIREDATE DATE , SALARY DECIMAL (7,2), COMM DECIMAL (7,2),

DB2 Database

1499

DB2 on zOS and Win XP Client

by: geoff | last post by:

Hi All, I am accessing db2 for zOS from a windows xp client and trying to find out how many times a select or update sql statement is executed. I am able to do this easily in db2 for windoze by by bringing up the monitor and generating a pre-defined report. I can also do it thru sql directly by using a snapshot function. However, none...

DB2 Database

3021

Multi-Row Inserts on DB2 for zOS

by: geoff | last post by:

I have a table called 'employee' with one column called 'name', a varchar. If I execute the following insert statements: insert into employee(name) values ('jones') insert into employee(name) values ('smith') insert into employee(name) values ('billy-bob') .. . . they work, no problem. If I execute the following: insert into...

DB2 Database

8663

Schema on Db2 database installed on Main frame machine zOS.

by: karanbikash | last post by:

Hi , I would like to know : 1.how to find all the schema in my DB2 database on Main frame machine . 2. How to see all the tables for a given schema . 3. What are the default schema in Db2 on Mainframe . zOS. I know all the above when I connect to DB2 on LUW ..

DB2 Database

7701

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...

General

7615

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...

Windows Server

8130

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...

Online Marketing

7677

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...

Windows Server

6284

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...

Career Advice

3653

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...

Networking - Hardware / Configuration

2115

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1223

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

940

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

General