Home
Search results “Load table conventional oracle”
Oracle Performance Tuning - Loading Data - 04 Direct Path Load
 
16:28
Connect with me or follow me at https://www.linkedin.com/in/durga0gadiraju https://www.facebook.com/itversity https://github.com/dgadiraju https://www.youtube.com/c/TechnologyMentor https://twitter.com/itversity
Views: 1984 itversity
SQL * Loader Tutorial 3: SQL Loader  Conventional and Direct Paths
 
04:43
SQL * Loader Tutorial 3: SQL Loader Conventional and Direct Paths Difference Between Conventional and Direct path loading in SQL * Loader SQL Tutorial SQL Tutorial for beginners PLSQL Tutorial PLSQL Tutorial for beginners PL/SQL Tutorial PL SQL Tutorial PL SQL Tutorial for beginners PL/SQL Tutorial for beginners Oracle SQL Tutorial
Views: 1785 TechLake
Oracle Performance Tuning - Loading Data - 05 Direct Path Load
 
14:51
Connect with me or follow me at https://www.linkedin.com/in/durga0gadiraju https://www.facebook.com/itversity https://github.com/dgadiraju https://www.youtube.com/c/TechnologyMentor https://twitter.com/itversity
Views: 1743 itversity
Video21 Using Oracle SQL Loader to load data from csv in to table
 
18:50
How to use sqlloader utility to load the bulk data from excelsheet in to oracle database
Data loading from flie to table using SQL*LOADER
 
17:32
Load the data from Flat file to database table using SQL*LOADER concept in Oracle Applications.
UTL FILE READ DATA AND INSERT INTO TABLE WITHOUT SQLLOADER
 
09:06
Oracle SQL PLSQL and Unix Shell Scripting
Views: 4300 Sridhar Raghavan
Instalar Sqlldr
 
03:42
Instalacion componente Sqlldr
Views: 5264 Fdo Luis
DevExpress WinForms: Getting Started with the Grid Control
 
07:27
The high performance DevExpress WinForms Data Grid is a feature-complete editing and data shaping component allowing your end-users to easily manage information and display it on-screen. It provides multiple data presentation modes: Standard Grid View, Banded and Advanced Banded Grid Views, Card, Tile and WinExplorer Views, Layout, Carousel and Split Presentation Views. This video walks you through the steps on getting started with the DevExpress Grid Control. Learn more on our website https://www.devexpress.com/Products/NET/Controls/WinForms/Grid/
Views: 210334 DevExpress
oracle dba training online How To export data using expdp  Using Sql
 
06:26
This video is about expdp utility oracle sql
Views: 19 Nayabsoft
How to load data from non oracle file to oracle file using Sql Loader. /* Step By Step /*
 
14:48
In this video i am showing you How We can transfer data from non oracle file to oracle Table. use Oracle Sql Loader export import datapump utility. I have data in test file with comma ( , ) separated column. so we can move this data to oracle useing sql loader. example: ename, sal, deptno Joy, 10000, 10 Scott, 2000, 20 Roy, 4000, 30 using this utility must have to create controlfile ( em.ctl load data infile append into table scott.test fields terminated by ',' optionally enclosed by '"' (ename,sal,deptno) Create table test with 3 column (ename,sal,deptno) rum sqlldr command sqlldr control=/u01/app/parag/em.ctl data=/u01/app/parag/em.txt log=/u01/app/parag/em.log Login to scott schema and check table It is very easy to implement.
Views: 859 Parag Mahalle
High Performance Bulk Data Loading
 
33:55
What is the best way to get data into an Oracle database? This session covers how to bulk load data quickly into an Oracle database. It will help developers avoid common gotchas that will limit performance, and it gives insight into how to make sure the solution will be database AND DBA-friendly! Example SQL is used to demonstrate the solution, and links to working examples will be provided.
SQLLoader Express Mode
 
07:58
#Oracle #SQLLoader #ExpressMode
Views: 220 Hemant K Chitale
How to use sqlldr in oracle in Hindi.
 
06:46
In this video i'm going to show you how to use sql loader and how to import non ORACLE DATA in ORACLE .
Views: 1895 OCP Technology
oracle bulk mode with indexes
 
03:38
This demo shows StreamHorizon achieving processing of 606K records/sec on heavily indexed (4 indexes on target fact tables) running with single CPU laptop & single hard disk
Views: 35 StreamHorizon
AskTOM TV - Direct path read
 
04:59
A video to help you understand the "thought process" behind answering AskTom questions. In this episode, we look at direct path reads and how they interact with objects that may already have changed buffers in the buffer cache blog: https://connor-mcdonald.com
Views: 568 Connor McDonald
Oracle DB - SQL Loader
 
31:15
Oracle DB - SQL Loader Watch More Videos at: https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited
SQL * Loader Tutorial 4 : SQL Loader Insert options INSERT, APPEND , REPLACE and TRUNCATE
 
05:09
SQL * Loader Tutorial 4 : SQL Loader Insert options INSERT, APPEND , REPLACE and TRUNCATE SQL Tutorial SQL Tutorial for beginners PLSQL Tutorial PLSQL Tutorial for beginners PL/SQL Tutorial PL SQL Tutorial PL SQL Tutorial for beginners PL/SQL Tutorial for beginners Oracle SQL Tutorial
Views: 705 TechLake
Database 12c Loading data with SQL*Loader
 
04:27
Oracle Database 12c Loading data with SQL*Loader
Views: 568 Ora Tube
Turning Relational Database Tables into Spark Datasources
 
55:43
https://developer.oracle.com/code/online | Kuassi Mensah: This session presents a Spark data source for joining big data with master data in an RDBMS. It describes how such an implementation: Allows parallel and direct access to the RDBMS database (with the option of controlling the number of concurrent connections). Introspects the RDBMS table, generates partitions of Spark JDBCRDDs based on the split pattern, and rewrites Spark SQL queries into the RDBMS SQL dialect. Uses hooks in the JDBC driver for faster type conversions. Pushes down predicates to the RDBMS, prunes partitions based on the where clause, and projects columns to the RDBMS to reduce the amount of data returned and processed on Spark. Writes back the result set to the RDBMS table for use by traditional BI tools
Views: 729 Oracle Developers
SQL *  Loader  Tutorial 2 : Control File with example
 
16:46
SQL * Loader Tutorial 2 : Control File with example Oracle SQL * Loader Tutorial with Control file Bad File Discard File Log file SQL Tutorial SQL Tutorial for beginners PLSQL Tutorial PLSQL Tutorial for beginners PL/SQL Tutorial PL SQL Tutorial PL SQL Tutorial for beginners PL/SQL Tutorial for beginners Oracle SQL Tutorial
Views: 1445 TechLake
How to Export and import oracle 10g database .rm
 
03:55
طريقة استيراد و تصدير قاعدة بيانات من أوراكل
Views: 78745 MahmoudRFarra
Oracle Performance Tuning - Loading data - 01 SQL Loader and loading from server
 
24:11
Connect with me or follow me at https://www.linkedin.com/in/durga0gadiraju https://www.facebook.com/itversity https://github.com/dgadiraju https://www.youtube.com/c/TechnologyMentor https://twitter.com/itversity
Views: 1239 itversity
Oracle Performance Tuning - Loading Data - 03 Using manual parallelism and changing initrans
 
13:50
Connect with me or follow me at https://www.linkedin.com/in/durga0gadiraju https://www.facebook.com/itversity https://github.com/dgadiraju https://www.youtube.com/c/TechnologyMentor https://twitter.com/itversity
Views: 885 itversity
Oracle SQL Loader - Introduction - Tutorial -1
 
07:47
This video is the first tutorial on Oracle SQL*Loader utility. This video gives the introduction and helps in understanding the concept behind Oracle SQL Loader. Why it should be used and the advantages of using it. SQL Loader is a bulk loader utility used for moving data from external files into the Oracle database tables. In this video we look at the overview of Oracle SQL Loader, we look at the complete flow of the process. It's basically a Conceptual introduction to the SQL Loader utility. What you will learn in this video 1. What is SQL Loader? 2. You will get an understanding on the Components of SQL Loader like control file, Log file, Discard File and Bad file. 3. Complete flow of the process. Visit the other videos on the same : Second video visit https://youtu.be/ogidUWHHRL8 Third video visit https://youtu.be/yD_CL_cf8tQ Check out the advantages of using TRUNCATE over a DELETE from the following video: Delete VS Truncate : https://youtu.be/u76wMm2byXo #KishanMashru #Oracle #SqlLoader #SqlLoaderConcept #SqlLoaderIntroduction #SQLandPLSQL #OracleSqlLoader #ETL #database
Views: 930 Kishan Mashru
Oracle - Datapump Import full example
 
07:25
Ejemplo de import full con oracle datapump, en plataforma windows. http://locutoriorama.blogspot.com.es
Views: 72184 locuto riorama
PL/SQL tutorial 74: PL/SQL Bulk Collect Clause with FETCH-INTO statement of an explicit cursor
 
09:49
RebellionRider.com presents a PL/SQL tutorial on how to use PL/SQL Bulk Collect with Fetch-Into statement of an explicit cursor in Oracle Database. Watch and learn how to enhance query performance with Bulk Collect in Oracle Database by Manish Sharma. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/bulk-collect-3 Previous Tutorial ► Introduction to Bulk Collect: https://youtu.be/HPVzFBluM_Q ► Explicit Cursor: https://youtu.be/3q7dW_d2KVc ► Simple Loop: https://youtu.be/AFx6QYcY1CU ► The script on GIT: https://github.com/RebellionRider/pl-sql-tut-74.git ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ For E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 10242 Manish Sharma
SQL Loader Bad file and Discard file Part 3  | Oracle SQL Tutorial | Mr.Murali
 
30:25
SQL Loader Bad file and Discard file Part 3 | Oracle SQL Tutorial | Mr.Murali ►For Registration : https://goo.gl/r6kJbB ►Call: +91-8179191999 ► Visit Our Website: http://nareshit.in/ http://nareshit.com/ ► About NareshIT: "Naresh IT is the Best Software Training Institute for Hadoop, Salesforce, AWS, DevOps, Sprak, Data Science, Python, Tableau, RPA ,Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in Hyderabad, Chennai and Vijayawada, India which provides online and classroom training classes" ►For Registration : https://goo.gl/r6kJbB ►Call: India- 8179191999, USA- 404-232-9879 Email: [email protected] ►Our Online Training Features: 1.Training with Real-Time Experts 2.Industry Specific Scenario’s 3.Flexible Timings 4.Soft Copy of Material 5.Share Video's of each and every session. Check The Below Links: ►For Course Reg : https://goo.gl/r6kJbB ► Subscribe to Our Channel: https://goo.gl/q9ozyG ► Circle us on G+: https://plus.google.com/NareshIT ► Like us on Facebook: https://www.facebook.com/NareshIT ► Follow us on Twitter: https://twitter.com/nareshitech ► Visit Our Website: http://nareshit.in/ http://nareshit.com/
Views: 5211 Naresh i Technologies
SQL Loader 01
 
07:26
SQL*Loader loads data from external files into tables of an Oracle database. It has a powerful data parsing engine that puts little limitation on the format of the data in the datafile. SQL Loader loads data from multiple datafiles during the same load session. into multiple tables during the same load session. Data File SQL*Loader reads data from one or more files specified in the control file. From SQL*Loader's perspective, the data in the datafile is organized as records. It may be in the form of (.csv, .dat, .txt) Data File is in the form of Delimiter Separator or Fixed Position File. Control File Control file used for loading the data. Provide the interface between data file and table The control file tells SQL*Loader where to find the data, how to parse and interpret the data, and where to insert the data. Extension of Control file is .ctl Log File Provide the information about the process of loading from data file to database. Extension of log file is .txt. Bad File BAD specifies the name of the bad file created by SQL*Loader to store records that cause errors during insert or that are improperly formatted. A bad file is not automatically created if there are no rejected records. extension of .bad Discard File Business Logic “When condition of WHERE CLAUSE is not true”. extension of .dsc
Views: 145 Data Science Center
Practice 4-1 : Extraction and Transportation Using SQL*Loader
 
10:36
BAGUS PRASETYA - 2110175022
Views: 32 Bagus Prasetya
SQL Loader Bad file and Discard file Part 2  | Oracle SQL Tutorial | Mr.Murali
 
22:40
►For Registration : https://goo.gl/r6kJbB ►Call: +91-8179191999 ► Visit Our Website: http://nareshit.in/ http://nareshit.com/ ► About NareshIT: "Naresh IT is the Best Software Training Institute for Hadoop, Salesforce, AWS, DevOps, Sprak, Data Science, Python, Tableau, RPA ,Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in Hyderabad, Chennai and Vijayawada, India which provides online and classroom training classes" ►For Registration : https://goo.gl/r6kJbB ►Call: India- 8179191999, USA- 404-232-9879 Email: [email protected] ►Our Online Training Features: 1.Training with Real-Time Experts 2.Industry Specific Scenario’s 3.Flexible Timings 4.Soft Copy of Material 5.Share Video's of each and every session. Check The Below Links: ►For Course Reg : https://goo.gl/r6kJbB ► Subscribe to Our Channel: https://goo.gl/q9ozyG ► Circle us on G+: https://plus.google.com/NareshIT ► Like us on Facebook: https://www.facebook.com/NareshIT ► Follow us on Twitter: https://twitter.com/nareshitech ► Visit Our Website: http://nareshit.in/ http://nareshit.com/
Views: 8323 Naresh i Technologies
SQL Loader 13
 
02:54
Views: 1443 lokesh nd
SQL Loader Part 4  | Oracle SQL Tutorial | Mr.Murali
 
20:41
SQL Loader Part 4 | Oracle SQL Tutorial | Mr.Murali ►For Registration : https://goo.gl/r6kJbB ►Call: +91-8179191999 ► Visit Our Website: http://nareshit.in/ http://nareshit.com/ ► About NareshIT: "Naresh IT is the Best Software Training Institute for Hadoop, Salesforce, AWS, DevOps, Sprak, Data Science, Python, Tableau, RPA ,Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in Hyderabad, Chennai and Vijayawada, India which provides online and classroom training classes" ►For Registration : https://goo.gl/r6kJbB ►Call: India- 8179191999, USA- 404-232-9879 Email: [email protected] ►Our Online Training Features: 1.Training with Real-Time Experts 2.Industry Specific Scenario’s 3.Flexible Timings 4.Soft Copy of Material 5.Share Video's of each and every session. Check The Below Links: ►For Course Reg : https://goo.gl/r6kJbB ► Subscribe to Our Channel: https://goo.gl/q9ozyG ► Circle us on G+: https://plus.google.com/NareshIT ► Like us on Facebook: https://www.facebook.com/NareshIT ► Follow us on Twitter: https://twitter.com/nareshitech ► Visit Our Website: http://nareshit.in/ http://nareshit.com/
Views: 4315 Naresh i Technologies
SQL * Loader Tutorial 5: SQL Loader SKIP & FILLER options
 
06:06
SQL * Loader Tutorial 5: SQL Loader SKIP & FILLER options SQL * Loader SKIP & FILLER options SQL Tutorial SQL Tutorial for beginners PLSQL Tutorial PLSQL Tutorial for beginners PL/SQL Tutorial PL SQL Tutorial PL SQL Tutorial for beginners PL/SQL Tutorial for beginners Oracle SQL Tutorial
Views: 797 TechLake
SQL * Loader Tutorial : Introduction To SQL * Loader
 
06:28
SQL * Loader Tutorial : Introduction To SQL * Loader Oracle SQL * Loader Tutorial Complete SQL * Loader Tutorial SQL Tutorial SQL Tutorial for beginners PLSQL Tutorial PLSQL Tutorial for beginners PL/SQL Tutorial PL SQL Tutorial PL SQL Tutorial for beginners PL/SQL Tutorial for beginners Oracle SQL Tutorial
Views: 689 TechLake
direct path to 9
 
00:41
direct path to 9
Oracle 18c New Feature Focus - Private Temporary Tables
 
31:38
Oracle 18c brings us Private Temporary Tables. A Private Temporary Table is stored in memory and is visible only to the session that created it and is dropped at the end of the session or transaction depending on the setup. In this webinar OCP DBA John Mullins will cover the creation and management of Private Temporary Tables along with their benefits and restrictions. In addition, Private Temporary Tables will be compared to Global Temporary Tables. Get the slides from this and other webinars at: https://www.themisinc.com/webinars
Views: 145 Themis Education
Como utilizar SQL Loader
 
12:18
En este video se explica como cargar informacion desde un archivo hacia una tabla en oracle.. espero que les sirva no olvooden SUSCRIBIRSE para mas videos de su interes..
Views: 3971 Joseph Channel
SQL Loader 11
 
04:27
Views: 1879 lokesh nd
SQL Loader 4
 
04:46
Views: 4541 lokesh nd
oracle sqlloader purpose of optionally enclosed by double quotes
 
12:59
Oracle SQL PLSQL and Unix Shell Scripting
Views: 210 Sridhar Raghavan
SQL Loader 2
 
01:52
Views: 5561 lokesh nd
Spark Tutorial - JDBC Source and Sink
 
13:59
In this Spark tutorial video, I am talking about Spark JDBC connector. This video explains a Spark JDBC connector use case. I also cover most of the JDBC connector internals and demonstrates multiple scenarios of reading from and writing to an RDBMS. You can find all the commands and source code used in this video at below location. ------------------------------------------------- https://www.learningjournal.guru/courses/spark/spark-foundation-training/jdbc-data-sources/
Views: 5187 Learning Journal
Your Data When, Where and How you want it..
 
36:05
EXTRACT, TRANSFORM & DELIVER IBM i DATA DIRECT FROM THE DATABASE AND FROM SPOOL FILES TO MULTIPLE FILE FORMATS AND OTHER DATABASES. The IBM i is a powerful transactional platform but extracting data from it in a meaningful format can be akin to pulling teeth. Shouldn't there be a QUICK and EASY method of transferring data, tailored for the end user in a format of choice? Wouldn't it be better if we could reliably and securely load SQL Server(s) at five times the speed of current technologies? RouteOne provides the answers. This multimodal solution supplies a complete data delivery suit in one application. RouteOne: http://www.linkedin.com/company/utilities-400/routeone-301094/product?trk=biz_product - Load IBM i data to SQL Server quickly and securely. Using 'pick-up' technology RouteOne DataDelivery can resume data load should a connection fail or terminate -- no need to restart. - Deliver data from spool files & direct from the database into PC formats such as Excel, Word, SQL, XML, Access and more. - Your data, your rules! RouteOne DataDelivery includes a rules engine that allows administrators to determine when, which and how data should be transferred in what format to whom. - Make data warehousing a breeze with data transfer speeds up to 5x quicker than conventional technology. Using the RouteOne turbo technology, data transfer speeds are not only quicker but more secure and reliable than client access. - Eliminate pre-printed stationary, make modern, reformatted forms of your own choosing. Using the powerful rules engine, merge data from the spool file and/or database with formatted documents (Word, Excel, etc.) - Transfer data to any platform, such as Windows, Oracle & IBM i including the IFS. - Automate document delivery, be it for sending formatted invoices in PDF via email or XML through FTP. Delivery can be scheduled to suit the activity and/or end user or triggered by events such as creation of a spool file or via workflow automation tools. Demonstration of IBM i to SQL/Oracle @ 07:40 Demonstration of Spool file for electronic form (PDF) delivered by email @ 15:25 Demonstration of IBM i data to XLS/XML and delivered by email @ 22:45
Views: 10859 Utilities400
[오라클 기초 강좌] 29 - SQL Loader - Conventional Path, Direct Path
 
31:25
강의 자료(PDF) 다운로드: https://goo.gl/VZovDV Conventional Path 에 의한 로드 - 데이터베이스 자원에 대해 모든 다른 Oracle Process와 경쟁을 함 - 직접적인(Direct) 경로보다 더 느릴 수 있음 - 데이터베이스에 삽입될 행들의 배열을 작성함 - 테이블에 행들을 삽입하기 위해 INSERT 구문을 사용함 - 다음과 같은 경우에 전통적인 경로(Conventional Path)를 사용함 * 네트워크를 통한 데이터 로드 시 * 클러스터화 된 테이블에 데이터 로드 시 * 인덱스화 된 대형 테이블에 상대적으로 적은 개수의 데이터를 로드 시 * 참조 무결 성 제약 조건과 칼럼 검사 무결 성 제약조건을 사용하여 대형 테이블에 상대적으로 적은 개수의 데이터를 로드 시 * 데이터 필드에 SQL 함수를 적용할 때 - ROWS Parameter는 데이터를 COMMIT 하기 전에 얼마나 많은 행들을 로드 할 것인지 명시하기 위해 사용됨 - 데이터베이스에 대한 모든 변경은 Redo Log 파일에 기록됨 - SQL*Loader는 데이터 로드 동안 테이블에 속하는 모든 인덱스를 유지 관리함 - 이런 행위를 중단시키기 위한 유일한 방법은 데이터 로드를 시작하기 전에 인덱스를 삭제하고 데이터 로드 후 여전히 그 인덱스가 필요하다면 다시 생성하는 것임 - 복수 개의 행들이 한 번에 읽혀져서 Binding 대상인 배열에 저장이 됨. 그 다음에 INSERT 명령이 한 번에 배열의 내용을 삽입하고 COMMIT 함 - Binding 대상인 배열은 적어도 한 개의 행을 소유하기에 충분한 크 기여야 함. 그렇지 않은 경우 에러 발생
Views: 826 최용진
mssql MDF File fragment carving  SQL database lost recovery
 
06:45
[email protected] www.dbfixserver.com Sell the database file fragments engraving software, and remote service recovery. downlink https://drive.google.com/open?id=0B42l4awBomKpUW1manNHU0xNcWc support MSSQL (MDF, NDF) mysql (ibd, myd ibdata1) oracle (DBF, ora, raw disk) interbase (GDB, ib, GBK) Firebird (FDB, FBK) sybase (DAT, db) exchange (EDB, bKF), and so on database file is missing debris sculpture as well as the damage repair recovery. Support undelete table row and undrop table, untruncate table; 我們目前開發的有 mssql mysql oracle sybase asa sybase ase access interbase Firebird 等數據資料庫 文件丟失恢復工具,當資料庫被誤刪除 誤格式化 或者 被誤被老備份還原后 使用常規的數據恢復軟件 掃描到的 文件基本上都是垃圾文件,雖然名字 和 大小 正確,但是其 內容 已經都是垃圾了。 這是因為 資料庫由於使用 頻繁 所以 在實際存儲中 會有很多碎片 數據恢復軟件 都是根據簇指針解析 或者 文件頭進行搜索,而我們的工 具 是 根據 文件結構 從磁盤扇區搜索 組合。所以成功恢復率可達99%. We have currently developed MSSQL mysql oracle sybase asa sybase ase access interbase Firebird data such as database Restore tool file is missing, when the database was mistakenly deleted mistakenly formatted or by mistake by old after reduction using conventional backup data recovery software to scan Files are basically junk files, although the name and size is correct, but its content is already are rubbish.This is because the database due to the use frequent So there will be a lot of debris in the practical storage data recovery software are based on cluster pointer parsing or file header to search, and our work Is according to the file structure From the disk sector search combination.So successful recovery rate can reach 99%.
Views: 255 Xin database
Fast & Efficient Db2 Data Migration
 
02:11
BCV5 quickly and efficiently copies, refreshes and replicates Db2 objects. BCV5 copies Db2 databases or tables within the same or different Db2 systems. When measured against conventional copying methods, BCV5 saves around 90% on elapsed copy time and resources consumed (SSU, SRU). For one customer a ten-hour unload/load process was reduced to slightly over one hour. A BCV5 copy task integrates both, the physical data movement and the DDL related requirements. It copies Db2 data, i.e. databases or tables with or without auxiliary objects – indexes, views, triggers, procs and runstats. BCV5 automatically handles the OBID translation and the RBA adaptation. Copy jobs are completed in minutes rather than hours. DBAs are no longer forced to wait for weekend time slots and are able to run copying jobs on regular weekday shifts. Test data on demand is a dream come true for QA, development and test staff. BCV5 offers relief where the need is greatest. It significantly cuts down runtime and cost. It reduces CPU consumption by 90%+ and shortens the preparation lead time required by the staff.
Views: 220 UBS Hainer