mmajorza52 Tracker

Has anyone automated a Metadata sync process between a PROD linux environment and a "cold" bcp linux environment on linux?

mmajorza52 — Thu, 28 Aug 2014 14:38:45 GMT

We have created a number of ExportPackage that run on our PROD server. The packages are replicated to our BCP server, and we have created a number of ImportPackage. These 2 servers are Linux servers. We would like to use cron to schedule these processes on a weekly basis, but we are not having any luck with running the Import/Export Package in a true background mode.

Script Example -

#!/bin/ksh

sasdir=/sas/share/SASPlatformObjectFramework/9.3
packdir=/users/apps/stg/superbid/metadata_migration
saslogdir=/users/apps/stg/superbid/metadata_migration

$sasdir/ExportPackage -host xxxxxxx -port xxxx -user xxxxxxx -password xxxxxx -package $packdir/SASGrid1_ACT_export_package.spk -objects "/System/Security/Access Control Templates(Folder)" -subprop -log $saslogdir/SAS_BATCH_EXPORT_ACT.log -since "Month to date"

Has anyone automated a Metadata sync process between a PROD linux environment and a "cold" bcp linux environment on linux?

mmajorza52 — Thu, 28 Aug 2014 14:02:04 GMT

Script Example -

#!/bin/ksh

sasdir=/sas/share/SASPlatformObjectFramework/9.3
packdir=/users/apps/stg/superbid/metadata_migration
saslogdir=/users/apps/stg/superbid/metadata_migration

Re: SAS Tables/Views and Columns Inventory

mmajorza52 — Fri, 18 Apr 2014 10:48:21 GMT

- They are SAS Datasets and SAS DataViews. They are NOT defined in Metadata.

- Users are using BATCH SAS, Enterprise Guide, SAS/Connect (rsubmit/endrsubmit).

- Parsing logs would be considered, but not from logs from 3000 users. Is there a more GLOBAL approach to turn on "logging" on? The Audit package seems to capture access rights, and capture when tables are updated (tables/columns), not so much from a READ perspective (I may be wrong). I came across RTRACE last night and still researching. I'm I wasting my time with this? Thanks for all the comments.

Re: SAS Tables/Views and Columns Inventory

mmajorza52 — Thu, 17 Apr 2014 13:51:31 GMT

To simplify, let's say i have 3 SAS Datasets under 3 differently directory paths called CUSTOMER. One has 50 columns, one has 60 columns, and one has 90 columns. Is there anyway to identify, who is accessing these tables via SAS Data or SAS PROCs and identify which columns are being requested (read). We are in the early stages of trying to consolidate "liked" data and remove columns not being used I know in NETEZZA, there is a system table that contains all SQL calls to a table. Was wondering if anything existed for SAS.

SAS Tables/Views and Columns Inventory

mmajorza52 — Thu, 17 Apr 2014 12:02:58 GMT

We are running SAS 9.3 on a Linux server and we have about 250 DataMarts spread across multiple file systems/directories. We have approx 3,000 users running adhoc queries against these DataMarts. These DataMarts contain multiple tables and views. Is there a way to determine what tables are being used and what columns are being used? We are in the process of "consolidating/house-cleaning". We want to identify "what" is being used and "what" is NOT being used at the COLUMN level.

Thanks