I need to use it to delete saparch directory as it becomes full every several hours during big loading/compression/ods activation etc. It should only be used in staging and dev. On prod, need another approach — backup everything in saparch, backup to tape, then clean up archive.
#!/usr/bin/ksh
# server SID
echo $1
# files to be kept
echo $2
cd /oracle/$1/saparch
cnt=`ls -1 $1arch*.dbf [...]
Since internal tables have fixed line structures, they are not suited to handle data sets with varying structures. Instead, you can use extract datasets for this purpose.
An extract is a sequential dataset in the memory area of the program. You can only address the entries in the dataset within a special loop. The index or [...]
Use t-code se54 to view table structure and content
Extractor related tables:
ROOSOURCE – On source system R/3 server, filter by: OBJVERS = ‘A’
Data source / DS type / delta type/ extract method (table or function module) / etc
RODELTAM – Delta type lookup table.
ROIDOCPRMS – Control parameters for data transfer from the source system, result of “SBIW [...]
Add the following statement to the TOP include of your function group.
Type-pools: SRSC.
The problem is that the TYPE has not be defined in your program, but in a TYPE Group or Type Pool. You need to reference the TYPE group when using that type. If you drill into the TYpe group statement above, you can [...]
It’s kind of scary to do init full load for delta whenever there’s a problem with data.
I am trying to gather what’s the best we can do, and what’s the catch.
Question:
I have loaded Inventory Data( Historical Stock Balances by using 2lis_03_BX) in to InfoCube 0IC_C03 from the year 2001 April. First we did Initialization(till 2004 [...]
The current size of all dimensions can be monitored in relation to fact table by t-code se38 running report SAP_INFOCUBE_DESIGNS
The ratio of a dimension should be less than 10% of the fact table.
In the report,
Dimension table looks like /BI[C/O]/D[xxx]
Fact table looks like /BI[C/0]/[E/F][xxx]
Use T-CODE LISTSCHEMA to show the different tables associated with a cube.
When a [...]
To copy CubeA to CubeB:
Option 1:
If CubeA is updated from ODS and ODS has all data you wanted, you can create update rules for CubeB and update it from ODS. This option can be used if no records has been deleted from ODS.
Option 2:
Right click on ‘Generate Export Datasource’ on CubeA under InfoProvider to make [...]
For BW 3.5
Get all PSA/change log tables:
select table_name, sum(num_rows) from all_tables where table_name like ‘%BIC/B000%’ group by table_name;
ignore tables with 0 records
Go to se11, find out the data source.
Go to rsa1 – psa – search for the data source – context menu – delete psa
Or use PSA cleanup process chain to delete them.
RSTSODS also holds all teh DS name and table name.
Parsing is the first step in the processing of any statement in an Oracle database. Parsing is the act of breaking the submitted statement down into its component parts, determining what type of statement it is (query, DML, or DDL), and performing various checks on it.
Parsing performs syntax check (whether the statement is valid) and [...]
ALE: Application Link Enabling – A means of creating and operating distributed applications; guarantees a distributed, but integrated, R/3 installation. This involves business-controlled message exchange using consistent data across loosely linked SAP applications. Applications are integrated using synchronous and asynchronous communication – not by using a central database.
ALE consists of the following layers:
Application services
Distribution services
Communication [...]