You can also define this parameter using the context when running a query from the VQL Shell ('Tools -> VQL Shell'). See the Remarks section for the list of available attributes. 8 Answers Hi, As you said, you can define the query timeout from the VDP Admin Tool: 'Tools -> Admin Tool Preferences -> Connection'. Enter Connection Fields Manually: Database Cluster Identifier: Amazon Redshift. Syntax bool PDOStatement::setAttribute (attribute, value ) Parameters attribute: An integer, one of the PDO::ATTR or PDO::SQLSRVATTR constants. Default Setting: In Version 9.7 Fix Pack 5 and earlier: 5 seconds In Version 9.7 Fix Pack 6 and later fix packs: 1 second Usage Notes: An application can use the SQLSetStmtAttr () function to set the SQLATTRQUERYTIMEOUT statement attribute or set the QueryTimeout keyword in the db2dsdriver.cfg file. Schema Name: The name of the Destination database schema. Note: ensure to redact or obfuscate all confidential or identifying information (eg. Sets an attribute value, either a predefined PDO attribute or a custom driver attribute. News, articles and tools covering Amazon Web Services (AWS), including S3, EC2, SQS, RDS, DynamoDB, IAM, CloudFormation, AWS-CDK, Route 53, CloudFront, Lambda, VPC, Cloudwatch, Glacier and more. Set the lock timeout before running the query: SET LOCKTIMEOUT 600000 - Wait 10 minutes max to get the lock.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |