The Complete Sybase ASE Quick Reference Guide

This quick start guide, which is excerpted from the larger User Guide, is intended to provide you with a focused overview of working with SAP ASE database objects in the Delphix Dynamic Data Platform. It does not cover advanced configuration options. It assumes you have already setup the Delphix Engine.

The Complete Sybase ASE Quick Reference Guide

Download: https://www.google.com/url?q=https%3A%2F%2Fjinyurl.com%2F2u3mPm&sa=D&sntz=1&usg=AOvVaw3guFf3oANSLX7-TZCtvInv

Hi Abhijit,Please use the following command to disable the dump configuration feature and then retry the dump command.sp_configure 'enforce dump configuration',0goRegards,Mark KusmaMessage was edited by: Mark Kusma (fixed command)\",\"author\":\"username\":\"sap_mk\",\"displayName\":\"Mark Kusma\",\"groupIcons\":[\"name\":\"employee\",\"title\":\"This user is an SAP Employee\",\"priority\":21],\"suspended\":false,\"isCurrentUser\":false,\"parentAuthor\":\"username\":\"abhijeet.siras\",\"displayName\":\"Abhijeet Siras\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":9765086,\"creationDate\":1358165873000,\"activeRevisionId\":10508822,\"lastActivity\":1358166878000,\"parentId\":9763427,\"originalParentId\":9731257,\"likeCount\":0,\"visibility\":\"full\",\"depth\":0,\"attachments\":[],\"canVoteUpOrCancel\":false,\"relations\":\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"isLiked\":false,\"type\":\"comment\",\"canVoteUpOrCancel\":false,\"canConvertToAnswer\":false,\"canBeModerated\":false,\"canViewRevisions\":false,\"showInReply\":false,\"reported\":false,\"canCancelReport\":false,\"canDelete\":false,\"canVoteDownOrCancel\":false,\"canComment\":false,\"canViewReports\":false,\"isCurrentUserAuthor\":false,\"liked\":false,\"moderatorComment\":false}]},\"10260951\":\"rootParentId\":10260951,\"commentsCount\":5,\"comments\":[\"body\":\"I just relalised - there is an error in my above reply , it should say:\\\" typically this is $SYBASE/$SYBASE_ASE/install/_BS.log\\\"You realised it obviously.The backup serer eerrror log displays messages of how far a DB dump has gone in terms of percentage. With kind regardsTilman Model-Bosch\",\"author\":\"username\":\"tilman.model-bosch\",\"displayName\":\"Tilman Model-Bosch\",\"groupIcons\":[\"name\":\"employee\",\"title\":\"This user is an SAP Employee\",\"priority\":21],\"suspended\":false,\"isCurrentUser\":false,\"parentAuthor\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"id\":10530501,\"creationDate\":1387529347000,\"activeRevisionId\":11143338,\"lastActivity\":1387529350000,\"parentId\":10530014,\"originalParentId\":9731257,\"likeCount\":0,\"visibility\":\"full\",\"depth\":0,\"attachments\":[],\"canVoteUpOrCancel\":false,\"relations\":\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"isLiked\":false,\"type\":\"comment\",\"canVoteUpOrCancel\":false,\"canConvertToAnswer\":false,\"canBeModerated\":false,\"canViewRevisions\":false,\"showInReply\":false,\"reported\":false,\"canCancelReport\":false,\"canDelete\":false,\"canVoteDownOrCancel\":false,\"canComment\":false,\"canViewReports\":false,\"isCurrentUserAuthor\":false,\"liked\":false,\"moderatorComment\":false],\"12597309\":\"rootParentId\":12597309,\"commentsCount\":1,\"comments\":[\"body\":\"Dear siras,\\n\\nIt's simple.. login to sidadm level and give the below commands\\n\\nisql -Usapsa -SSID -Ppassword -X\\nuse SID\\ngo\\ndump database SID to "/db/backupname.dmp"\\ngo\\n\\n..this is how are taking in suse linux...\\n\\nRegards,\\nsudheer\",\"author\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"parentAuthor\":\"username\":\"marco.veisa\",\"displayName\":\"Marco Veisa\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":12597949,\"creationDate\":1474019586000,\"activeRevisionId\":12861859,\"lastActivity\":1474019588000,\"parentId\":12597309,\"originalParentId\":9731257,\"likeCount\":0,\"visibility\":\"full\",\"depth\":0,\"attachments\":[],\"canVoteUpOrCancel\":false,\"relations\":\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"isLiked\":false,\"type\":\"comment\",\"canVoteUpOrCancel\":false,\"canConvertToAnswer\":false,\"canBeModerated\":false,\"canViewRevisions\":false,\"showInReply\":false,\"reported\":false,\"canCancelReport\":false,\"canDelete\":false,\"canVoteDownOrCancel\":false,\"canComment\":false,\"canViewReports\":false,\"isCurrentUserAuthor\":false,\"liked\":false,\"moderatorComment\":false],\"9749178\":\"rootParentId\":9749178,\"commentsCount\":1,\"comments\":[\"body\":\"i followed your suggestion\\nplz help in below\\n\",\"author\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"parentAuthor\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"id\":12455349,\"creationDate\":1466493898000,\"activeRevisionId\":12743742,\"lastActivity\":1466493906000,\"parentId\":9749178,\"originalParentId\":9731257,\"likeCount\":0,\"visibility\":\"full\",\"depth\":0,\"attachments\":[],\"canVoteUpOrCancel\":false,\"relations\":\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"isLiked\":false,\"type\":\"comment\",\"canVoteUpOrCancel\":false,\"canConvertToAnswer\":false,\"canBeModerated\":false,\"canViewRevisions\":false,\"showInReply\":false,\"reported\":false,\"canCancelReport\":false,\"canDelete\":false,\"canVoteDownOrCancel\":false,\"canComment\":false,\"canViewReports\":false,\"isCurrentUserAuthor\":false,\"liked\":false,\"moderatorComment\":false]}"); const simplifiedQuestionView = JSON.parse("true"); (function() window.pageContext = mergeDeep(pageContext, question: id: 9731257, plug: "sybase-database-backup", votes: 1, questionTitle: "Sybase Database Backup", isClosed: false, isLocked: false, isRedirected: false, redirectedFromTitle: "", redirectedFromId: "", closedStatusData: JSON.parse(""), userVoted: false, relations: JSON.parse("\"canClose\":false,\"canUnredirect\":false,\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"canReopen\":false,\"type\":\"question\",\"canVoteUpOrCancel\":false,\"canViewRevisions\":true,\"score\":1,\"canUnlock\":false,\"reported\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canCancelReport\":false,\"canComment\":true,\"isCurrentUserAuthor\":false,\"canViewReports\":false"), isQuestionAccepted: true , childToViewInfo: id: "" , comments: JSON.parse("\"9731708\":\"rootParentId\":9731708,\"commentsCount\":15,\"comments\":[\"body\":\"Hi Abhijit,Please use the following command to disable the dump configuration feature and then retry the dump command.sp_configure 'enforce dump configuration',0goRegards,Mark KusmaMessage was edited by: Mark Kusma (fixed command)\",\"author\":\"username\":\"sap_mk\",\"displayName\":\"Mark Kusma\",\"groupIcons\":[\"name\":\"employee\",\"title\":\"This user is an SAP Employee\",\"priority\":21],\"suspended\":false,\"isCurrentUser\":false,\"parentAuthor\":\"username\":\"abhijeet.siras\",\"displayName\":\"Abhijeet Siras\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":9765086,\"creationDate\":1358165873000,\"activeRevisionId\":10508822,\"lastActivity\":1358166878000,\"parentId\":9763427,\"originalParentId\":9731257,\"likeCount\":0,\"visibility\":\"full\",\"depth\":0,\"attachments\":[],\"canVoteUpOrCancel\":false,\"relations\":\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"isLiked\":false,\"type\":\"comment\",\"canVoteUpOrCancel\":false,\"canConvertToAnswer\":false,\"canBeModerated\":false,\"canViewRevisions\":false,\"showInReply\":false,\"reported\":false,\"canCancelReport\":false,\"canDelete\":false,\"canVoteDownOrCancel\":false,\"canComment\":false,\"canViewReports\":false,\"isCurrentUserAuthor\":false,\"liked\":false,\"moderatorComment\":false],\"10260951\":\"rootParentId\":10260951,\"commentsCount\":5,\"comments\":[\"body\":\"I just relalised - there is an error in my above reply , it should say:\\\" typically this is $SYBASE/$SYBASE_ASE/install/_BS.log\\\"You realised it obviously.The backup serer eerrror log displays messages of how far a DB dump has gone in terms of percentage. With kind regardsTilman Model-Bosch\",\"author\":\"username\":\"tilman.model-bosch\",\"displayName\":\"Tilman Model-Bosch\",\"groupIcons\":[\"name\":\"employee\",\"title\":\"This user is an SAP Employee\",\"priority\":21],\"suspended\":false,\"isCurrentUser\":false,\"parentAuthor\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"id\":10530501,\"creationDate\":1387529347000,\"activeRevisionId\":11143338,\"lastActivity\":1387529350000,\"parentId\":10530014,\"originalParentId\":9731257,\"likeCount\":0,\"visibility\":\"full\",\"depth\":0,\"attachments\":[],\"canVoteUpOrCancel\":false,\"relations\":\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"isLiked\":false,\"type\":\"comment\",\"canVoteUpOrCancel\":false,\"canConvertToAnswer\":false,\"canBeModerated\":false,\"canViewRevisions\":false,\"showInReply\":false,\"reported\":false,\"canCancelReport\":false,\"canDelete\":false,\"canVoteDownOrCancel\":false,\"canComment\":false,\"canViewReports\":false,\"isCurrentUserAuthor\":false,\"liked\":false,\"moderatorComment\":false],\"12597309\":\"rootParentId\":12597309,\"commentsCount\":1,\"comments\":[\"body\":\"Dear siras,\\n\\nIt's simple.. login to sidadm level and give the below commands\\n\\nisql -Usapsa -SSID -Ppassword -X\\nuse SID\\ngo\\ndump database SID to "/db/backupname.dmp"\\ngo\\n\\n..this is how are taking in suse linux...\\n\\nRegards,\\nsudheer\",\"author\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"parentAuthor\":\"username\":\"marco.veisa\",\"displayName\":\"Marco Veisa\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":12597949,\"creationDate\":1474019586000,\"activeRevisionId\":12861859,\"lastActivity\":1474019588000,\"parentId\":12597309,\"originalParentId\":9731257,\"likeCount\":0,\"visibility\":\"full\",\"depth\":0,\"attachments\":[],\"canVoteUpOrCancel\":false,\"relations\":\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"isLiked\":false,\"type\":\"comment\",\"canVoteUpOrCancel\":false,\"canConvertToAnswer\":false,\"canBeModerated\":false,\"canViewRevisions\":false,\"showInReply\":false,\"reported\":false,\"canCancelReport\":false,\"canDelete\":false,\"canVoteDownOrCancel\":false,\"canComment\":false,\"canViewReports\":false,\"isCurrentUserAuthor\":false,\"liked\":false,\"moderatorComment\":false],\"9749178\":\"rootParentId\":9749178,\"commentsCount\":1,\"comments\":[\"body\":\"i followed your suggestion\\nplz help in below\\n\",\"author\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"parentAuthor\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"id\":12455349,\"creationDate\":1466493898000,\"activeRevisionId\":12743742,\"lastActivity\":1466493906000,\"parentId\":9749178,\"originalParentId\":9731257,\"likeCount\":0,\"visibility\":\"full\",\"depth\":0,\"attachments\":[],\"canVoteUpOrCancel\":false,\"relations\":\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"isLiked\":false,\"type\":\"comment\",\"canVoteUpOrCancel\":false,\"canConvertToAnswer\":false,\"canBeModerated\":false,\"canViewRevisions\":false,\"showInReply\":false,\"reported\":false,\"canCancelReport\":false,\"canDelete\":false,\"canVoteDownOrCancel\":false,\"canComment\":false,\"canViewReports\":false,\"isCurrentUserAuthor\":false,\"liked\":false,\"moderatorComment\":false]"), answerPager: answersCount: 8, page: 1, pageSize: 10, pageCount: 1, sort: "votes" , answers: JSON.parse("[ Chamber of Commerce 27138666\\n-----------------------------------------------------------------\",\"author\":\"username\":\"rob.verschoor\",\"displayName\":\"Rob Verschoor\",\"groupIcons\":[\"name\":\"employee\",\"title\":\"This user is an SAP Employee\",\"priority\":21],\"suspended\":false,\"isCurrentUser\":false,\"id\":9731708,\"posted\":1356294346000,\"votes\":1,\"isAccepted\":true,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"score\":1,\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"accepted\":true,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[],\"body\":\"Hi Abhijit,\\n\\nin order to use functionality you are referring to, you should run at least ASE 15.7.0.021. So please upgrade your ASE as per Note 1599814 - SYB: Installing ESDs for Sybase ASE 15.7 (UNIX + Linux)\\nOnce upgraded, please refer to Note 1588316 - SYB: Configure automatic database and log backups\\nand also Note 1585981 - SYB: Ensuring Recoverability for Sybase ASE\\n\\nIt is also always worth reading through the following note Note 1772967 - FAQ - Important SAP Notes - Sybase ASE and apply recommendations, which applicable to your installation.\\n\\nHope this helps\\n\\nRegards,\\nKonsatntin\",\"author\":\"username\":\"former.employee\",\"displayName\":\"Former Member\",\"groupIcons\":[\"name\":\"employee\",\"title\":\"This user is an SAP Employee\",\"priority\":21],\"suspended\":true,\"isCurrentUser\":false,\"id\":9732171,\"posted\":1356335581000,\"votes\":1,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"score\":1,\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[],\"body\":\"Hi Abhijeet,Instead of using command line tools to take backup why not use transaction code dbacockpit from sapgui to take database backup. This is very easy to use and you may plan the backups like we do in transaction code db13.Regards,Deepak Kori\",\"author\":\"username\":\"deepak.kori2\",\"displayName\":\"Deepak Kori\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":9732034,\"posted\":1356329763000,\"votes\":0,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[],\"body\":\"Hi Abhijit,\\n\\nPlease use fallowing commands to take the sybase backup from os level ,\\n\\nlogin with sidadm\\n\\nisql -Usapsa -SSID -PMasterpassword\\n1>dump database SID to "/backup/SIDbkp050113.dmp"\\n2>go\\n\\nRegards,\\nPrabhakar\",\"author\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"id\":9749178,\"posted\":1357378884000,\"votes\":0,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[],\"body\":\"Dear All,\\n\\nSorry for late reply , since due to some reason one of the log file in server deleted .\\n\\nI am closing this discussion and newly open session for the recovery of database.\\n\\nThanks for your support.\\n\\nRegards,\\nAbhijit\",\"author\":\"username\":\"abhijeet.siras\",\"displayName\":\"Abhijeet Siras\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":9804634,\"posted\":1359705081000,\"votes\":0,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[],\"body\":\"Hey man\\n\\nTake a look on a Blog that I wrote. I believe it will be helpfull..\\n\\n -ase/blog/2013/05/31/backup-challenges-on-sybase\\n\\nBR \\n\\nFred\",\"author\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"id\":10260951,\"posted\":1378310008000,\"votes\":0,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[],\"body\":\"Dear Abhi,\\n\\nwe are also using the sybase database. I will take at os level using the following procedure. It's very simple.\\n\\nLogin as ADM and execute the below command. I think no need to use master command for taking backup.\\n\\nsidadm: isql -Usapsa -SSID -Ppassword -X\\ngo\\ndump database SID to "/db/.dmp"\\ngo\\n\\nRegards,\\nvenkata sudheer akondi.\",\"author\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"id\":12455734,\"posted\":1466501319000,\"votes\":0,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[],\"body\":\"Hi, \\nI hope this will be usefull for everything. \\n \\nYou have two ways.The first: \\nLogin using a console. \\nisql -Usapsa -X -DSID \\nInput Password \\nuse master \\ngo \\ndump database SID to '/inst/backup/backupname' with compression = '101' \\ngo \\n \\nObviously, the path depends on the host operating system or storage device. \\nWith this, you'll have your backup file with the name and path chosen. \\n \\nThe second: \\nisql -Usapsa -X -DSID \\nInput Password \\nuse master \\ngo \\nsp_config_dump @config_name='DUMPDATABASE', \\n@stripe_dir = '/inst/backup', \\n@compression = '101' \\n@verify = 'header' \\ngo \\n \\nNow if you enter sp_config_dump you will get something like: \\n \\n \\nFor reference parameters, see this link: \\nSyBooks Online \\n \\nNow, if you want a backup, all you have to do is: \\ndump database SID using config = 'dumpdatabase' \\ngo \\n \\nIt is necessary to use the master database to make it work: \\nuse master \\ngo \\n \\n \",\"author\":\"username\":\"marco.veisa\",\"displayName\":\"Marco Veisa\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":12597309,\"posted\":1473977152000,\"votes\":0,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[\"id\":1629220,\"fileName\":\"pastedImage_8.png\",\"size\":\"10.5 kB\",\"url\":\"/storage/attachments/1629220-pastedImage_8.png\",\"isImage\":true]]"), answerForm: formAction: "/answers/9731257/post.json", textareaName: "body", textareaErrors: "", isAttachmentsEnabled: true, answerEditorialGuideline: title: "Before answering", content: "You should only submit an answer when you are proposing a solution to the poster\'s problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instruc