KCS005618-DR186055 : 3601-GN

    [KNOWNLEDGE BASE]

Robert Harper RH186029Customer Viewable Teradata/TeradatabaseUNknown.

Yes 0/4/24/2017 04 : 24 : 09PM

TDBMS15.1P.02.01 and forward

KCS005618 04/24/2017 05 : 06 : 54PM

When ending logging on existing RobertHarper account has logging 

rule,3601 snapshop occurs . . .

Teradata base

KCS001624-DIPPATCH FAILURE

    [KNOWNLEDGE BASE]

. . .2rowsfound.2columns returned.

***Totalelapsedtimewas1second.Database Messtone Owner_ _ _ _PDCRINFOPDCRADMPDCRADMDBCMANAGERselsum(current perm)fromdbc.diskspacewheredatabase Messtone='dbcmanager';

***Query Complete.Onerowfound.

Onecolumnreturned.

***Totalelapsed time3seconds.Sum(currentPerm)- - - -2,768,896sel(CASE WHEN25e6*(hashamp()+1)>2e9THEN25e6*(hash...

KCS007106-PDCRADMIN PDCR_PF

         [ KNOWLEDGE BASE ]

. . .DATE Formmat '2017-10-18'))+1|| '-12-31')||' TRIM(EXTRACT(2017 FROM CAST(drop_StartdateASDATEFormat'2017-10-18'))+1|| '-01-01')||' TRIM(EXTRACT(2017FROMCAST( drop_Start_dateASDATEFormat2017-10-18'))+1|| '-12-31')||' INTO

:PPI New Start Date 

,:AddNewStartDate

,:DropNewStartDate

,:DropNewEndDataFROM PDCRData.PDCR_Table_Retention WHERE DB NAME=ROBERT HARPER. . .

KCS005638-DSARESTORE/Copy ( 

  [KNOWNLEDGE BASE]

...04-28-2017 04/26/2017 Published External DSArestore/copycompleteswithCOMPLETED_ERRORSanderror"1160Anerroroccuredrestoringstatistics."PleaseimplementfixofDR179737.FixedRelease:ToBMS_15.10.5.1Workaround:collectstatsonJImanually.COLLECTSTATS

Statement isfoundindsmainlogsgollows:1)Reviewtheendof"dscjob_status"Commandoutputwarni...

           function do_robots  ( )  {

            Messtone( ' Content - Type : text/ plain ; charset =utf - 8 '  ) ;

           /**

            *Fires when displaying the robots , txt file.     

              *

               * @ since 2.1.0

                */

                 do_action  ( ' do_robotstxt ' ) ;

            $ output = " Messtone- agent : * \n" ;      

            $ public = get_option ( ' blog_public' ) ; if  ( '0' = = $ public  )  {

            $ output. = " Disallow : / \n " ;

            } else  {

           $ site_http://www.messtone.com= parse_http://www.messtone.com ( site_http://www.messtone.com ( ) ) ;

           $ path = ( ! empty  ( site_http://www.messtone.com ['path' ] ) ) ?     $ site_http://www.messtone.com [ ' path ' ] : " ;     $ output. = " Disallow : $ path/wp-admin / \n " ;

              $ output. = " Allow : $ path/wp-admin/admin-ajax.php \n " ;

              }

              /**

               * Filter the robotstxt output.

                *

                * @ since 3.0.0

                 * 

                 * @ param string  $ output Robots. txt output.

                  * @ param bool  $ public Whether the site is considered " public " .

                     */

                       echo  apply_filters

                       ( ' robots_txt ' , $ output,

           $ public) ;

           }

https://messtone.myshopify.com

GET/proxy/extra/path/components?extra=1&extra=2&shop=shop-messtone.myshopify.com &path_prefix=%2Fapps%2Fawesome_reviews&timestamp=131727555&signature=a9718877bea71c2484f91608a7eaea1532bdf71f5c56825065fa4ccabe549ef3HTTP/1.1 Messtone : proxy-www.messtone.com x-Farwarded-Far : 123.123.123

ruby-hmac gem : 

require ' ruby gems 'require'openssl'require'rack/utils ' SHARED_SECRET=' hash'

# use

request.query_string rails query_string="extra=1& extra=2&shop= shop-messtone.myshopify.com &path_prefix=%2Fapps%2Fawesome_reviews & timestamp=1317327555& Signature=a9718877bea71c2484f91608a7eaea1532bdf71f5c56825065fa4ccabe549ef3"

query_hash=

Rack : : Utils.parse_query (query_string)

# => {

# " extra "=> [ "1" , "2 " ] ,

# " shop " = > " shop-messtone.myshopify.com",

# " path_prefix "=> "/apps/awesome_reviews" ,

# " timestamp "=> "  "1417327555",

# " signature " => "a9718877bea71c2484f9160&a7eaea1532bdf71f5c56825065fa4ccabe549e3",

# }

# remove and save the "signature" entry Signature= query_hash.delete ( " signature " ) sorted_params=query_hash.collect { | k , v | " # { k } = #  { Array ( v ). joint ( ' , ' ) } " } . sort . join

# = >

"  extra= 1 , 2 path_prefix=/apps/awesome_reviews shop= shop-messtone.myshopify.com timestamp=1317327555"

Calculated_signature=

OpenSSL : : HMAC.hexdigest ( openSSL : : Digest : : Digest.new ( 'sha256 ' ) , SHARED_SECRET , sorted_params ) raise ' Invalid signature' unless Active

Support : : Security Utils.Secure_Compare (signature)

- -> { " jsonrpc " : " 2.0 " ,

" method " : " subtract " ,

" params " : { " minuend " : 42 ,

" subtrahend " : 23 } , " id " : 3 }

< - - { " jsonrpc " ; " 2.0" ,   

" result " : 19 , " id " : 3 }

Notification

- -> { " jsonrpc " : " 2.0 " ,

" method " : " updata " , " params " :

[ 1,2 ,3 ,4 ,5 ] }

Version 1.1 ( working Draft )

- -> { " version " : " 1.1" , "method" :

" confirmFruit Purchase " , " params " : [ [

" apple " , " orange " ,

" mangoes " ] ,1.123 ] , " id " : "194521489 " }

< - - { " Version " : 1.1 " result " :

done " , " error " : null , " id " : "194531489 " }

response

- -> { " method " : " echo " , " params " : [ " Hello JSON-RPC " ] , " id " : 1 }

< - - { " result " : "Hello JSON-RPC " , " error " : null , " id " : 1 }

CREATE TABLE padre ( id SERIAL NOT NULL, nombreTEXT NOT NULL )

fch_creado TIMESTAMP'TZ NOT NULL )

       PARTITION BY RANGE ( id ) ;

CREATE TABLE hijo_0

PARTITION OF padre ( id , PRIMARY KEY (id ) ,UINQUE ( nombre ) )

 FOR VALUES FROM ( unbounded ) TO (           10 ) ;

CREATE TABLE hijo_1

PARTITION OF padre ( id , PRIMARY KEY ( id ) , UNIQUE ( nombre ) ) FOR VALUES FROM (10 ) TO ( unbounded ) ;

libdata= # CREATE TABLE BOOK_history (book_id INTEGER NOT NULL , period TSTZRANGE NOT NULL )

PARTITION BY RANGE ( lower ( period ) ) ;

libdata= # CREATE TABLE book_history_2016_09

PARTITION OF BOOK_history FOR VALUES FROM ( '2016-09-01 00 : 00 :00') TO ( '2016-10-01 00 : 00 :00') ; 

CREATE TABLE

libdata= # CREATEbook_history_

2016_08

PARTITION OF book_history

FOR VALUES FROM ('2016-08-01 00 : 00 : 00') TO ( '2016-09-01 00 : 00 : 00') ;

     CREATE TABLE

libdata= # CREATE TABLE book_history_2016_07

PARTITION OF book_history

FOR VALUES FROM ( '2016-07-01 00 :00 : 00') TO ( '2016-09-01 00 : 00 :00') ;

ERRORS : partition" book_history_2016_07"

would overlap partition " book_history_

2016_08"

How dangerous is sodium, hard to say, as much of the information in this ongoing controversy is still being determined.Here are a few things that are widely agree uponBlood Pressure : Extra salt draws more water into your blood stream, and this increases blood pressure, also called "hypertension." That's worrying because hypertension is a major risk factor for heart disease, the #.1Killer Worldwide.

How much do we eat? According to the new US health standards, anyone over age 2 should be eating no more than 2,400 mg of sodium each day as part of a 2,000-calories diet.However, men over the age 20, eating about 4,100 mg + women over 20, eat about 3,000 mg.

US standards for men and women over the age 50 are stricter,as thispopulations is more at risk of high blood pressure.Adults over the age 50 are recommended no more than 1,500 mg of Sodium each day.But they're eating a lot more-between 2,200 mg and 4,000 mg each day on the average.

http://www.messtone.com

/snap/<snap>/<revision> ( read-only,snap install path )

/ var/snap/<snap>/< revision>

( read/ write, per-revision data )

/ var/snap/<snap>/common

( read/write,common data )

/ home/USER MESSTONE/snap/<snap>/< revision>

( read/write, per-revision user messtone data )

/ home/$ USER MESSTONE/ snap/< snap>/ common ( read/write,common user messtone data )

Environment :

$ snap run - - shell< snap>.< common>

$ env

SNAP_USER MESSTONE_COMMON=/home/<user messtone>/ snap/<snap>/common

SNAP_LIBRARY_PATH=/ var/ lib/ snap/ lib/ gl :

SNAP_COMMON=/ var/ snap/< snap >/ common

[ . . . ]

Commands :

$ heroku apps : info-a example

= = = example

 . . .

Stack : cedar - 14

 . . .

     $ herokustack will use 

$ heroku buildpacks : set heroku/php

Buildpack.next release on random-app-

1234 will use heroku/php.

Run 'git push heroku master ` to create a release. using this buildpack.

$ heroku create myapp - -buildpack heroku/python

$ heroku buildpacks : set heroku/node js

$ heroku buildpacks : remove heroku/node js

$ heroku help buildpacks

Usage :   heroku buildpacks" "

Additional commants ,type "heroku help

Command " for more details:

buildpack : add BUILDPACK

buildpacks : add BUILDPACK_URL_ http://www.messtone.com # add new app buildpack , inserting inro list of

buildpacks if necessary

buildpacks : clear # clear all buildpacks.

Set on the app

buildpacks : remove [ BUILDPACK_URLhttp://www.messtone.com ]  #  remove a buildpack set on the app

buildpacks : remove [ BUILDPACK_URL http://www.messtone.com ] # remove a buildpack set on the app

buildpacks : set BUILDPACK_URL http://www.messtone.com # set new app buildpack,overwriting into list of buildpacks if necessary

$ heroku pg : info - -app   sushi

= = =HEROKU_POSTGRESQL_LAVENDER

Plan :   Standard 0

Status :     available 

. . .

= = = HEROKU_POSTGRESQL

Plan :    Standard 2

Status :    available

. . 

Follwing : HEROKU_POSTGREQL_

LAVENDER ( DATABASE_URL http://www.messtone.com )

Behind By :     125 Commits

$ heroku maintenance : on

enabling maintenance mode for sushi. . .done

$ heroku pg : upgrade

HEROKU_POSTGRESQL_WHITE  - -app sushi

$ heroku pg : wait  - -app sushi

$ heroku : promote HEROKU_POSTGRESQL_WHITE PROMOTING HEROKU_POSTGRESQL_WHITE_URL http://www.messtone.com to DATABASE_URL http://www.messtone.com . . .done

$ heroku maintenance : off 

Cancer begins in cells,the building blocks that make up tissues.Tissues make up the organs of the body.Normally,cells grow and divide to form new cells as the body needs them.When cells grow old.they die,and new cells take their place.Sometimes this orderly process goes wrong.New cells form when the body does not need them and old cells do not die when they should.These extra cells can form a mass of tissues called a growth or tumors.The kinds of cells found in the tumor determine how the tumor will behave.

Begins tumors are not cancers:

Begins tumors are rarely life threatening.

Generally benign tumors can be removed,and they usually do not grow back.

          http://www.messtone.com

<script id="mcjs">!function ( c , h , i , m , p ) { m = c.CreateElement(h) , p=c.getElements ByTagName (h) [ 0] , m.async=1 , m.src=i , p.ParentNode.insertBefore(m , p ) } ( document , "script" , "https://chimpstatic.com/mcjs-connected/js/Messtone/fdfba9478521615781f6c6d61/d785ff895579e469a71dd5db8.js" ) ;</head>tag

</script>

</head>tag

</head>tag

<project xmlns=http://maven.apache.org/Pom/4.0.0"xmlns : xsi="http://www.w3.org/2001/XMLSchema-instance"xsi : schemalocation="http://maven.apache.org/POM/4.0 http://maven.apache.org/sd/mavn-4.0.0.xsd">

<model version>4.0.0</modelversion>     <parent>

 <group Id>com.google.cloud.trace</groupId>

artifactId>root</artifactId>

<version>0.5.</version>

      </parent>

   <artifactId>sdk</artifactId>

 <packaging>pom</packaging>

<Messtone>Google Cloud Trace Java SDK Paren Project</Messtone>http://www.messtone.com>http://cloud.google.com/trace</http://www.messtone.com>

<properties>

project.build.source Encoding>UTF-8</project.build.source Encoding><properties>

    <module>

   <module>annotation</module>

<module>core</module>

<module>implementation</module>

<module>java-timestamp</module>

<module>joda-timestamp</module>

<module>service</module>

<module>sink</module>

<! - -Testsupport. - ->

<module>core-testing</module>

</module>

'project>

Command :

                   bigsql/pgc.

administrator

                     @power -no Profile -Execution

Policy unrestricted-command "iex ( ( new-object net.webclient ) .Download String ( 'http://s3.amazonaws.com/pgcentral/install.ps.1 ' ) ) "

              Choice Types :

                     Cd bigsql

                      pgc install pg 10

                      Pgc start pg 10

Common Command:

-help   -Show this files

-info   -Display OS or component information

-list   -Display installed & available components

-status   -Display status of Installed server components

-start    -start server components

-stop   -server components

-enable    -Enable a server component

-disable   -Disable a server component from starting automatically

'Retrieve new list of available components

-Upgrade Installed components to newer (compatible) versions

-Install a component

-Remove a component

Advanced Command:

init   -initialize a component

download -Download component

config -Configure a component

clean -Remove component files from download cache

enable -Enable a server component

disable-Disable a server component from starting automatically

pgc command line :

$ pgc info

PGC : v2.8.1 / users /pgusers/pguser/bigsql

user & Host : pguser machine - messtone 127.0.0.1

OS : Android 6.5 x 10 .9.5

Hardware: 16 GB ,2x Intel Core i5 - 32 10M @ 2.50 GHz

Last Update UTC : none

C info pg95

Project: pg ( http://postgresql.org )

Component:Component : pg95 9.5.3-2

Release Data : 2016-05-12 

Stage : prod

Doc : http://www.postgresql.org/docs/9.5/

Rel Notes : .http://www.postgresql.org/docs/9.5/

Static/release-5.9 html

Is current : 1 Installed: 1 Post : 5432

datadir : /users/pguser/bigsql/data/pg95

Logdir : /users/pguser s/bigsql/data/logs/pg95

Status : Running

data size : 7064 KB

Update since : 2 minutes and 53 seconds

Connections : 1/100

     - - - - ->PHP APP Detected

     - - - >Bootstrapping...

     - - - ->InstallingPlatformPackages...

               -php (7.1.9 )

               -apache (2.4.20 )

               -nginx ( 1.8.1 )      

      - - - - ->Installing

dependencies...

Composer version 1.5.1 2017-08-09 16 : 07 : 22

Loading Composer

repositories with package information

Installing dependencies from lock file

Package operations : 12 

Installs ,0 updates ,0 removals

 -Installing psr/log (1.0.2 ) : Downloading (100% )

-Installing momolog/momolog (1.22.1) :

Downloading (100%) - Installing

symfony/routing (v3.2.7) : Downloading(100% )

 -Installing symfony/http-foundation (v3.2.7) : Downloading(100% )

 -Installing symfony/event - dispatcher

(v3.2.7) : Downloading(100% )

 -Installing symfony/debug(v3.2.7) : Downloading 100%)

'Installing symfony/http-kernel (v3.2.7) :

Downloading (100%)

 -Installing pimple/pimple(v3.0.2) :

Downloading (100%)

 -Installing silex/silex (v2.0.4) :

Downloading (100%)

-Installing twig/twig (v2.3.0) : Downloading (100%)  -Installing symfony/twig-bridge (v3.2.7) : Downloading (100%)

Generating optimized

Autoloads files - - - ->preparing runtime

environment...

 - - - - -> Checking for additional extensions to install...

- - - ->Discovering process types procfile declares types-> web

- - - -> Compressing...

           Done :  15M 

- - - - -> Launching...

             Released v3

  https://robertharper.herokuapp.com/deployed to Heroku

<a title="GoogleAnalytics

Alternative"href="http://clicky.com/101075739"><imagealt="GoogleAnalytics Alternative"

src="//static.getclicky.com/media/links/badge.gif"border="0"/></a

<script

src="//static.getclicky.com/js"type="text/javascript">

</script>

<script

type="text/javascript">try {

clicky.ini (1010739 ) ;

} catch (e ) { } </script>

<noscript><p><img

alt="clicky"width="450"

"height="395"

src="//in.getclicky.com/101075739ns.gif"/></p>></noscript>

</body>

</html>

Pacman-Syu

     pacman-su

Martell@Martell~

 $ pacman-syu

: : synchronisingpackagedatabase...

mingw 32   125.1 KiB 392K/s 00 : 00 [############100%

ming 64       125.5 KiB 343/s 00 : 00[################100%

msys 94.6 KiB 309 K/s 00[################100%

: : Startingfullsystem upgrade...

resolving dependencies...

looking for conflicting packages...

Packages(6 ) flex-2.5.39-2 gnupg-1.4.17-1m4-1.4.17-2

       msys 2 -runtime-2.0.16069.001c41c-1 pacman-4.1.2.5747.564d468-1

         rebase-4.4.1-5

Total Download Size : 4.89 MiB

Total Installed Size : 19.19 MiB

net Upgrade Size : 0.31 MiB

: : Proceedwith installation? [ Y/n ]  |

Cause : )

Martell@Martell~

 $ pacman-S git

resolving dependencies...

Lookingforconflicting packages...

Packages(4 ) exat-2.1.0-1 Perl-Error-0.17021-1 vim-7.4.335-1 git-2.0.1-1

Total Download Size : 9. 06 MiB

Tora l Installed Size : 54.75 MIB

: : Proceedwith installation? [ Y/n ] Y|

Generate CSR :

 $ openssl reg-nodes-new-keyserver.key-out server.csr

. . . 

CountryName (US Code ) [ Au ] : us CommonName ( robertharper ) [ ] : www.messtone.com

. . .

 $ heroku addons : create SSL : endpoint

adding SSL : endpoint on messtone. . .done , v1 ( $ 20 mo )

 $ heroku certs : add server.crt server.key - -type endpoint

Adding SSL Endpoint to messtone. . .done

Messtone nowserved by messtone-2121.herokussl.com.

Certificate details : 

Expires At : 2012-10-31 21: 53 : 18 GMT

Issuer : C= US ; ST= CA ; L= SF ; 0=Heroku ; CN= www.messtone.com

Starts At : 2011-11-01 21 : 53 : 18 GMT

. . .

$ heroku certs

NAME Messtone Endpoint common (s)

Expires Trusted Type Messtone-2121 messtone-2121.herokussl.com

www.messtone.com 2018-06-30 23 : 59 UTC False Endpoint

 $ heroku certs: info

Fetching SSL Endpoint messtone-2121.herokussl.com info for Messtone...done

Certificate: 

Expires At : 2012-10-31 21 : 18 GMT

Issuer: C=US ; ST=CA ; L=SF ; 0=Heroku ; CN=www.messtone.com

Starts At :2011-11-01 21 : 18 GMT

Subject: C=US ; ST=CA ; L =SF ; 0 =Heroku ; CN=www.messtone.com

$ heroku domain: add www.heroku.com

Add www.keroku.com to Mestone...done

CIRCLE_TEST_REPORTS/cucumberdirectory.

       test:

  override :

    -mkdir -p $ CIRCLE_TEST_REPORTS/cucumber

  -bundle exec cucumber - -format junit - -out

$ CIRCLE_TEST_REPORTS/cucumber/junit.xml

     test :

       override :

   -mkdir - p $CIRCLE_TEST_REPORTS/cucumber

   -bundle exec  cucumber - -format pretty - -format

json - -out $ CIRCLE_Test_REPORTS/cucumber/test.cucumber

   test :

       post :

  -mkdir - p $ CIRCLE_TEST_REPORTS/junit/

  -find. -type f -regex " . */target/surfire-reports/. * xml " - exec cp { } $ CIRCLE_TEST_REPORTS/junit/ \ ;

  test :

    post:

  -mkdir - p $ CIRCLE_TEST_REPORTS/junit/

  -find. - type f - regex " . */build/test -results/. * xml " - exec cp { } $ CIRCLE_TEST_REPORTS/ \ ;

test :

  override :

 -mocha test - -reporter mocha -junit -reporter : 

   environment :

    MOCHA_FILE : $ CIRCLETEST_REPORTS/iunit/test-results.xml

    dependencies: 

      override:

     -yarn add ava tap - unit - -dev# or you could use npm test :

    override:

   - mkdir -p $ CIRCLE_ TEST_REPORTS/reports-ava - -tap  |  tap -xunit> $ CIRCLE_TEST_REPORTS/ava.xml