frayos

#DATA#
ls -la  /opt/sas/viya/config/data/compsrv/default
#LOG#
ls -la /opt/sas/viya/config/var/log/compsrv/default
#RUN#
ls -la /opt/sas/viya/config/var/run/compsrv/default/
ls -la /opt/sas/viya/config/var/run/compsrv/default/*/
#SPOOL#
ls -la /opt/sas/viya/config/var/spool/compsrv/default
ls -la /opt/sas/viya/config/var/spool/compsrv/default/*/

frayos

export HADOOP_USER_CLASSPATH_FIRST=yes
export HADOOP_CLASSPATH=/opt/sas/SASEP/SASEPHome/jars/sasep-hdp2-1.3.30-m.1.jar
hadoop com.sas.access.hadoop.ep.utils.AdminUtil -version

## Version ........: 2.7.3.2.6.1.0-129
##  Build ..........: 2.7.3.2.6.1.0-129 from 45e64533cdee3edf67c7b88a0267c64c194f93e5 by jenkins source checksum deba7ab784606611731cd7c37443e1c
##  Date ...........: 2017-05-31T03:06Z
##  Branch .........: (HEAD detached at 45e6453)
##  Revision .......: 45e64533cdee3edf67c7b88a0267c64c194f93e5
##  URL ............: git@github.com:hortonworks/hadoop.git

frayos

/***************************************************************************
 *
 * EP VALIDATION TEST
 * SAS 9.4 M2 IN-DATABASE DEPLOYMENT PACKAGE
 * ----------------------------------------------------------------------
 *
 * Based on Shakedown Version 5 as shared by T.Keefer, T.Bates
 * Testing:
 *  - Data movement back and forth between technologies
 *  - Access to data in HDFS, Hive, SPDE, LASR

frayos

@echo on
setlocal
reg query HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\Configuration\ /v CDNBaseUrl
if %errorlevel%==0 (goto SwitchChannel) else (goto End)
:SwitchChannel
reg add HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\Configuration /v CDNBaseUrl /t REG_SZ /d "http://officecdn.microsoft.com/pr/492350f6-3a01-4f97-b9c0-c7c6ddf67d60" /f
reg delete HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\Configuration /v UpdateUrl /f
reg delete HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\Configuration /v UpdateToVersion /f
reg delete HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\Updates /v UpdateToVersion /f
reg delete HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Office\16.0\Common\OfficeUpdate\ /f

frayos

#+ is to force for non standard port
nmap --script +ssl-enum-ciphers -p <port> <FQDN>

frayos

data new;
time=minute(time());
do until(i=time+10);
x=time();
i=minute(time());
output;
end;
run;

frayos

/********* Author Nicolas Housset *******************/
/* Declaration de l'environnement */ 

%let mySasServer=franih-hdp261.ts.sashq-r.openstack.sas.com;
%let mytkgridroot=franih-hdp261.ts.sashq-r.openstack.sas.com;
%let myLasrHost=franih-hdp261.ts.sashq-r.openstack.sas.com;
%let TKGridInstallDir=/opt/sas/TKGrid;
%let TKGridRepInstallDir=/opt/sas/TKGrid_REP;

frayos

options msglevel=I sastrace='d,,d,d' nostsuffix sastraceloc=saslog; 
options sql_ip_trace=all; 

%let NTZSERVER="test"; 
%let NTZUSER="user";
%let NTZPWD="password";
%let NTZDB="databasename";
%let NTZSCHM="DPO_STO_01";
%let NTZTABLE="DL_CRM_LEAD_FEEDBACK_MC";

frayos

#!/bin/bash 
cd /tmp
sudo yum -y install unzip strace curl wget
sudo rm -rf hadooptracer.zip* hadooptracer.py* hadooptracer.log* jars/ sitexmls/
wget ftp://ftp.sas.com/techsup/download/blind/access/hadooptracer.zip
unzip -o hadooptracer.zip
chmod 755 ./hadooptracer.py
sudo -u hive python hadooptracer.py --filterby=latest --postprocess -f /tmp/sitexmls/hadooptracer.json
cd /tmp/jars
sudo rm -rf derby*.jar

frayos

JCE 8 Oracle
http://www.oracle.com/technetwork/java/javase/downloads/jce8-download-2133166.html

JCE 7 Oracle
http://www.oracle.com/technetwork/java/javase/downloads/jce-7-download-432124.html

Zulu Azul JCE 7 
https://cdn.azul.com/zcek/bin/ZuluJCEPolicies.zip